Thread: ?? What Function Do I Need ??
View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.worksheet.functions,Microsoft.public.excel
Alan Foxmore Alan Foxmore is offline
external usenet poster
  
Posts: 5
Default ?? What Function Do I Need ??

"Bernd" wrote in message
oups.com...
Hello Alan,

Please look at Excel's help for these formulas.

Another suggestion:

=RATE((enddate-startdate)/365,0,-1000,1100)




I tried =RATE(0.5,0,-1000,1100)

and it returned 21%.

I'll need to research it more but thanks!



Reply With QuoteReply With Quote