CAGR Formula in Excel

CAGR is the steady annual rate that takes a start value to an end value over n years.

=(End/Start)^(1/n) - 1
=(B2/B1)^(1/5) - 1
=RRI(5, B1, B2)

Start ≤ 0 produces errors or meaningless rates. Guard inputs before raising to 1/n.

=IF(OR(B1<=0,B2<0,n<=0),NA(),(B2/B1)^(1/n)-1)