Thread: percent change
View Single Post
  #2   Report Post  
JE McGimpsey
 
Posts: n/a
Default

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?