Argument types

date
Unix style serial day number. This is the number of seconds since midnight on January 1, 1970.
format
A character string containing a valid C language format specification for converting character expressions to numeric and vice versa.
i
The interest rate per period on a loan or investment, expressed as a decimal fraction.
n
Any integer.
pmt
The payment made at the end of each term of a loan or investment.
position
An integer value specifying the position inside a character string.
pv
The present value of a series of payments. The original amount of a loan or investment.
range
A range name or cell address.
term
The number of payment period over the life of a loan or investment.
string
A character string enclosed in quotes or the cell address of a label.
x,y
Double precision floating point numbers or cells containing such numbers.