More precisely, the PV and FV values must have opposite signs.


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com


"JC" wrote in message
...
I figured it out... FV MUST BE a negative number.

"JC" wrote:

I am trying to use the RATE function, and I am at a loss for
why I always get
the #NUM! error. I viewed this document:
http://office.microsoft.com/en-us/as...092321033.aspx. I
tried
referencing values within cells as well as entering them
directly into the
formula, both failed. Any ideas?