Formula question...
 

I am drawing a huge blank. I need the formula for change over prior year.
For example, if I need to know the change between 2001 and 2000 is the
formula:

A) =(2001-2000)/2001

or

B) =(2001-2000)/2000

Your help is greatly appreciated! Thanks!!!!

B.

That is the percentage change from 2000 to 2001.


--
Rutgers_Excels
------------------------------------------------------------------------
Rutgers_Excels's Profile: http://www.excelforum.com/member.php...fo&userid=8973
View this thread: http://www.excelforum.com/showthread...hreadid=389151

HROBERTSON wrote:
I am drawing a huge blank. I need the formula for change over prior year.
For example, if I need to know the change between 2001 and 2000 is the
formula:

A) =(2001-2000)/2001

or

B) =(2001-2000)/2000

Your help is greatly appreciated! Thanks!!!!


It depends on what you're trying to calculate. Say your 2000 data was 100 and
your 2001 data was 200. Then your first approach would tell you the 2000 data
was 50% less than 2001.

Your second approach would tell you that the 2001 data was 100% higher than 2000.

These are not the same things as you can see and which you want depends on what
you're doing.

Bill