PMT()
 

PMT() uses 360-Days Bases method to return an annuity or interest. I need
such a formula / function, which calculate interest on 365-Days bases. Can
any body help me in this respect

PMT()
 

See one answer in microsoft.public.excel.worksheet.functions

Please don't post the same message to multiple groups. It tends to
fragment your answers, and potentially wastes the time of others
answering a question that's already been addressed.


In article ,
Mujeeb ur Rehman, FBL-GRW-PK
m wrote:

PMT() uses 360-Days Bases method to return an annuity or interest. I need
such a formula / function, which calculate interest on 365-Days bases. Can
any body help me in this respect