Rate function problem

[jeff]

Why can you not enter 9 or 10 for the nper in the rate
function?

 

[Bernard Liengme]

What makes you think you cannot?
Bernard

 

[Ron Rosenfeld]

Why can you not enter 9 or 10 for the nper in the rate
function?

I can.


--ron

 

[Norman Harker]

Hi Jeff!

Try:
=RATE(9,-1750,10000,0,0,0)
Returns: 10.1966330776603%

If you are getting the error #NUM! you'll need to change your guess
rate.