View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Fred Smith[_4_] Fred Smith[_4_] is offline
external usenet poster
 
Posts: 2,389
Default Calculate Interest Rate

You want the Rate function. Details in Help.

Regards,
Fred.

"Mark Parent" wrote in message
...
If I have opening and closing balances, and the number of equal monthly
payments made, can I calculate the 'effective' interest rate?