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)