PMT function
i am doing a spreadsheet 4 a gym. i need to use a PMT function to find
the monthly payment the customer needs to pay.
there is a fee for the membership, a deposit is paid initially, and the
interest rate is 4.75% annual of the amount to be paid.
but when i do this i get a negative figure, which means that the
customer needs 2 pay -£'s a month in order to pay the amount they owe
after they have paid there deposit, this cannot be correct.
please help
--
joemoran7
|