6 Replies Latest reply on May 2, 2014 4:20 AM by JudeAshton

    How to do Compound interest calculations in FMP?

    JudeAshton

      Title

      How to do Compound interest calculations in FMP?

      Post

           Hi there,

           I am using FMPro 13 on Apple Mac. I have Excel that uses a formula

            

           =FV(Appendix!B3,'Personal Details'!B39,0,-B4,0)

            

           While I know it references other sheets, I am trying to recreate the formula in FMPro. We have data in the database it references.

            

           I have tried to do the FV command, but we are struggling trying to get it to do the compound interest. Any ideas?

            

           Thanks in advance.