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?