I apologize if this post is a duplication of 100 other people finding
the same thing, but I have been unable to see reference to it
elsewhere. I have Excel 2003 11.8117.8107 SP2.

for the Rate(Nper, Pmt, PV) equation I have found a strange case.

=RATE(998,860042,-37200000) -- 2.312%
Now if I lower the present value, I would except the rate to increaes
which it does:
=RATE(998,860042,-17200000) -- 5.00%

But the odd case is when I change the PV to something in between the
two it should give a result near 3.5%.... but instead it gives this
error
=RATE(998,860042,-27200000) -- #NUM

Any help would be appreciated or at least verification that this same
error is happening with other peoples version of Excel.