-
If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.
compound annual growth rate
- Thread starter MATT67
- Start date
Andrew Poulsom
MrExcel MVP
- Joined
- Jul 21, 2002
- Messages
- 73,092
Use the RATE function:
=RATE(2,,-100,800) = 182.8%
or
=(800/100)^(1/2)-1 = 182.8%
The years are one less than in the series.
=RATE(2,,-100,800) = 182.8%
or
=(800/100)^(1/2)-1 = 182.8%
The years are one less than in the series.
Upvote
0
