View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.misc
Fred Smith Fred Smith is offline
external usenet poster
 
Posts: 623
Default Cagr=+(l13/f13)^(0.1666667)-1

I would expect the formula is calculating Compound Average Growth Rate. If so,
L13 would be the earnings, F13 is the amount invested, and 0.1666667 is the term
(ie, 1/6 of a year or two months).

--
Regards,
Fred


"Donovan" wrote in
message ...

Can anyone explain how the formula works and what the ^ means in this
formula.


--
Donovan
------------------------------------------------------------------------
Donovan's Profile:
http://www.excelforum.com/member.php...o&userid=35234
View this thread: http://www.excelforum.com/showthread...hreadid=567548