Today’s function is CAGR. It returns the compound annual growth rate.

 

Today’s function is CAGR. It returns the compound annual growth rate.

=LAMBDA(values, RRI(COUNT(values)-1,INDEX(values,1),INDEX(values,COUNT(values))))