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.

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.

thank u so much jim cone.
much appreciated.

paul.

"Jim Cone" wrote:

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.