Thread: Formula for Annualized percentage
View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Sat-Geek Sat-Geek is offline
external usenet poster
  
Posts: 1
Default Formula for Annualized percentage

Thanks for your input. I tried your suggestion and it returned a date
(1/13/00)

I used =365/(B1-A1)*(C1) with the cells corrected to the actual data
cells, in this case: =365/(F5-C5)*(I5)

F5=8/3/06
C5=7/31/06
I5=11.31% (return from another formula)

Did I do somnething wrong?

Thanks
Sat-Geek


--
Sat-Geek
------------------------------------------------------------------------
Sat-Geek's Profile: http://www.excelforum.com/member.php...o&userid=37091
View this thread: http://www.excelforum.com/showthread...hreadid=568196

Reply With QuoteReply With Quote