| Home |
| Search |
| Today's Posts |
|
|
|
#1
|
|||
|
|||
RATE returns the #NUM! error value
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? |
|
#2
|
|||
|
|||
|
Post the exact formula you are using.
-- Cordially, Chip Pearson Microsoft MVP - Excel Pearson Software Consulting, LLC www.cpearson.com 1 "JC" wrote in message ... 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? |
|
#3
|
|||
|
|||
|
For reference for others:
the syntax: =RATE(Nper,Pmt,Pv,Fv) this is what failed: =RATE(3,65,1072.29,1000) this is what worked: =RATE(3,65,-1072.29,1000) "Chip Pearson" wrote: Post the exact formula you are using. -- Cordially, Chip Pearson Microsoft MVP - Excel Pearson Software Consulting, LLC www.cpearson.com 1 "JC" wrote in message ... 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? |
|
#4
|
|||
|
|||
|
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? |
|
#5
|
|||
|
|||
|
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? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| When I enter a number in an empty cel, de cel returns the value d. | Excel Discussion (Misc queries) | |||
| How do I get carriage returns to not be row delimiters in text fi. | Excel Discussion (Misc queries) | |||
| Vlookup returns incorrect match | Excel Discussion (Misc queries) | |||
| GET.CELL | Excel Worksheet Functions | |||
| Rate of return required formula | Excel Worksheet Functions | |||
Hybrid Mode
