Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Using the RATE function in Excel, I get a NUM error.
Hi Everyone,
I'm using the formula RATE to find out the growth rate for the number of periods of 10 years, the payment of 0, present value .43, and the future value of 2.11. I always get the error "NUM". I wonder if something is formatted incorrectly. I don't put values in for type and guess. I'm not sure what else to do. |
#2
|
|||
|
|||
Using the RATE function in Excel, I get a NUM error.
The initial cash infusion (PV) must have the opposite sign of the FV. The
assumption is that you will spend cash to initiate the investment, cconsequently, a negative number. The future value will be that cash back to you. PV: -0.43 FV: 2.11 Payment: 0 Term: 10 Rate: 17.2415% Does that help? €¢€¢€¢€¢€¢€¢€¢€¢€¢€¢ Regards, Ron "donm" wrote: Hi Everyone, I'm using the formula RATE to find out the growth rate for the number of periods of 10 years, the payment of 0, present value .43, and the future value of 2.11. I always get the error "NUM". I wonder if something is formatted incorrectly. I don't put values in for type and guess. I'm not sure what else to do. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
CONVERT Function Disappered in Excel | Excel Discussion (Misc queries) | |||
error opening excel 2000 files | Excel Discussion (Misc queries) | |||
error opening excel file | New Users to Excel | |||
error opening excel file | Excel Worksheet Functions | |||
CHR() function not working in Excel 2003 | Excel Discussion (Misc queries) |