View Single Post
  #8   Report Post  
Posted to microsoft.public.excel.worksheet.functions
joeu2004 joeu2004 is offline
external usenet poster
 
Posts: 2,059
Default What are the calcs in PMT

On Nov 22, 11:13 am, Micky G wrote:
I understand the %/months a year, I understand the content of the chosen
cells but what is being done with the contents in them. They are obviously
not being added together, what's the calculation between the rate, number of
payments and the principal amoiunt.??


Oh, so you would like to know the mathematical formula for computing
the payment. Look at the PV Help page. Solve for "pmt".