JE,

Do you know of a formula that will give the correct %change regardless of
the sign of the two values? I've always used nested IFs but I think there's
likely a better way.

If the starting number is negative (-10) and the ending number is positive
(5) those calcs produce a negative %change eventhough the change is obviously
positive.
--
Jim


"JE McGimpsey" wrote:

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?