NPER
Returns the number of periods for an investment based on
periodic, constant payments and a constant interest rate.
Syntax...
NPER(rate, pmt, pv, fv, type)
--
Jim Cone
Portland, Oregon USA
http://www.realezsites.com/bus/primitivesoftware
(Excel Add-ins / Excel Programming)



"pm_sam"
wrote in message
Hi all
Ive got Excel 07,but am stuck .

I used the PMT function to calculate to pay off a credit card by entering
the APR and how long i wanted to pay and the balance that was on the card to
tell me how much to pay each month.
Am now want to calculate if i paid off a SET AMOUNT EACH MONTH with the APR
how long this will take but i dont know the function to use.
Any help from you guys and gals would be much appreciated.
Paul.