View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Bernie Deitrick Bernie Deitrick is offline
external usenet poster
 
Posts: 5,441
Default for 500000, 72 months, 9.5% interest how to calculate EMI

=PMT(9.5%/12,72,500000)

HTH,
Bernie
MS Excel MVP

"Chandrasekaran" wrote in message
...