It's so easily done with a formula:
A1: <starting number
A2: <ending number
A3: =(A2-A1)/A1
(which gives percent change when you format A3 as a percentage), that I
suspect the designers didn't feel a separate function, with its
overhead, was necessary.
Note: One could also be a bit more efficient:
A3: =A2/A1 - 1
again formatting A3 as a percentage.
In article ,
"stephenm" wrote:
I cannot find a formula to calculate the percentage change between two
numbers. I can write a formula which gives the answer, but I'm curious why
Excel doesn't have this formula in the drop down lists. Am I missing it?
|