I meant FV (future value)
FV
See Also

Returns the future value of an investment based on periodic, constant
payments and a constant interest rate.

Syntax

FV(rate,nper,pmt,pv,type)

For a more complete description of the arguments in FV and for more
information on annuity functions, see PV.

Rate is the interest rate per period.

Nper is the total number of payment periods in an annuity.

Pmt is the payment made each period; it cannot change over the life of the
annuity. Typically, pmt contains principal and interest but no other fees or
taxes. If pmt is omitted, you must include the pv argument.

Pv is the present value, or the lump-sum amount that a series of future
payments is worth right now. If pv is omitted, it is assumed to be 0 (zero),
and you must include the pmt argument.

Type is the number 0 or 1 and indicates when payments are due. If type is
omitted, it is assumed to be 0.


--
Don Guillett
SalesAid Software

"Don Guillett" wrote in message
...
Look in the help index for INT and other financial functions.

--
Don Guillett
SalesAid Software

"ms kitty" <ms wrote in message
...
I need to create a payment function to display a positive number and a
formula for the total interest. It's 5% rate, time 3, loan 12,000. Also
how
do I do status? what lookup funtion?