Welcome guest. Before posting on our computer help forum, you must register. Click here it's easy and free.

Author Topic: Excel formula to find rate of interest from cash flow  (Read 1061 times)

0 Members and 1 Guest are viewing this topic.

[email protected]

    Topic Starter


    Newbie

    • Experience: Experienced
    • OS: Windows 10
    Excel formula to find rate of interest from cash flow
    « on: November 09, 2018, 03:16:53 AM »
    I keep getting a number error whenever I type the RATE formula in Excel. The syntax of the RATE formula is =RATE(nper,pmt,pv,[fv],[type],[guess]). I have tried to type actual values instead of cell addresses in this formula. I have also increased the number of iterations to 1000 but the error persists. Please tell me what is wrong.

    John1397



      Hopeful
      Re: Excel formula to find rate of interest from cash flow
      « Reply #1 on: November 18, 2018, 08:01:07 AM »
      Try this