FORMULA

[Guest]

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

 

[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

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:

 

[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

compares a current year total to a previous year total.
The resulting percentage may be positive or negative. As
an example: