FORMULA

S

SHAMATNE

I need to create a formula to calculate percentage that compares a current year total to a previous year total. The resulting percentage may be positive or negative. As an example
year 2004 1837 year 2003 1765 the percentage difference is a 4.1% increas
year 2004 1765 year 2003 1837 the percentage difference is a 3.9% decreas

How would I create a formula to calculate that percentage

Thanks in advance
 
F

Frank Kabel

Hi
if A1 stores your 2003 value and B1 the 2004 value use the following
formula
=B1/A1-1
and format the resulting cell as percentage

--
Regards
Frank Kabel
Frankfurt, Germany

SHAMATNE said:
I need to create a formula to calculate percentage that compares a
Click to expand...
current year total to a previous year total. The resulting percentage
may be positive or negative. As an example:
 
M

mzehr

Hi,
Try =(CY-PY)/ABS(PY) where CY represents the Current
Variable, and PY represents the Prior Variable. Using the
Absolute function will allow you to evaluate trends that
may have a negative value.

HTH
-----Original Message-----
I need to create a formula to calculate percentage that
Click to expand...
compares a current year total to a previous year total.
The resulting percentage may be positive or negative. As
an example:
 
Top