1.

Solve : Excel formula to find rate of interest from cash flow?

Answer»

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.Try this



Discussion

No Comment Found