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

« previous next »
Pages: [1]   Go Down

Author Topic: Excel formula to find rate of interest from cash flow  (Read 2585 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.
    Logged

    John1397



      Hopeful
      • Experience: Beginner
      • OS: Windows XP
      Re: Excel formula to find rate of interest from cash flow
      « Reply #1 on: November 18, 2018, 08:01:07 AM »
      Try this
      Logged
      Pages: [1]   Go Up
      « previous next »