WordPerfect Office Ideas Portal
Add a new idea Subscribe
Created by Guest
Created on Aug 13, 2025

RELATED IDEAS

The CD accumulated interest function does not work

I was using the accumulated interest for a CD. I was getting the ERR message so I recreated the example in the Help directory list for this function and it also created the same error message. I am using Quattro Pro Professional 2021. Any updates for this?

  • Attach files
  • Frank Reibold
    Aug 14, 2025

    Click Insert -> Formula and use the formula composer (wizard).

    The help uses this example:

    @ACCRINTM(@DATE(89,12,15),@DATE(90,3,11),0.10,1000000,2)

    The correct formula is:

    @ACCRINTM(@DATE(1989;12;15);@DATE(1990;3;11);0.1;1000000;2)

    Apparently, they changed the separator from comma to semicolon (at least on my system in Germany)

    1 reply