Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
value error
I was trying to copy an example from excel help(I typed in nper function into
the search box) into a worksheet and was getting a value error. Why was I getting this and how can I make it so I do not have the value error? Here is what I was trying to copy: A B Data Description 12% Annual interest rate -100 Payment made each period -1000 Present value 10000 Future value 1 Payment is due at the beginning of the period (see above) Formula Description (Result) =NPER(A2/12, A3, A4, A5, 1) Periods for the investment with the above terms (60) =NPER(A2/12, A3, A4, A5) Periods for the investment with the above terms, except payments are made at the beginning of the period (60) =NPER(A2/12, A3, A4) Periods for the investment with the above terms, except with a future value of 0 (-9.578) And here is what happened when I pasted it: A B Data Description 12% Annual interest rate -100 Payment made each period -1000 Present value 10000 Future value 1 Payment is due at the beginning of the period (see above) Formula Description (Result) #VALUE! Periods for the investment with the above terms (60) #VALUE! Periods for the investment with the above terms, except payments are made at the beginning of the period (60) #VALUE! Periods for the investment with the above terms, except with a future value of 0 (-9.578) -- Amy Howell |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Error: "Excel encountered an error and had to remove some formatti | Excel Discussion (Misc queries) | |||
Counting instances of found text (Excel error? Or user error?) | Excel Worksheet Functions | |||
I have Error 1919 Error Configuring ODBC dataSource Database | Excel Discussion (Misc queries) | |||
Excel 2003 Macro Error - Runtime error 1004 | Excel Discussion (Misc queries) |