ANSWERS: 3

I may have misunderstood what you want to do, if so I apologise. Say you have a figure in cell A1 and a larger figure in A2 and you want to know by what % it has risen. The formula '=(A2A1)/A1*100' will do it.

If your original number is in cell A1 and the new number is in A2, the formula is: =A2/A11 then format as a percentage If you have a series of numbers (i.e. annual increase) the formula is: =((last number)/(first number))^(1/(count1))

=((LN(A1)LN(A20))/COUNTA(A1:A20))*100
Copyright 2020, Wired Ivy, LLC