Thread: Dont know Excel Function
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
 
Posts: n/a
Default Dont know Excel Function
Hello,

An example for 3% p.a.:

monthly rate =RATE(12,0,-1,1+3%)

which is equal to

=(1+3%)^(1/12)-1

HTH,
Bernd

Reply With QuoteReply With Quote