Calculating percentages

[tssjhs]

I am trying to calculate the pertcentage of increases and decreases from
month to month sales figures, what would be the formula if the absolute value
of a cell < or > on a changing basis.

12/31/2004 % Change # 1/31/2005

$308,902,200 #VALUE! $250,870,126
$5,947,716 $17,550,462
$176,223,397 #DIV/0! $4,237,754

Thanks so much...Teresa

 

[JE McGimpsey]

one way:

B2: =C2/A2 - 1

format B2 as a percentage. Copy down as far as required.

 

[tssjhs]

is there a way to calculate the pertcentages when there are variables from
month to month in a group see below

12/31/04 01/31/05
$308,902,200 -59% $490,901,200
$5,947,716 -85% 3,217,161
$176,223,397 -1% 177,223,397

How do I get the formula to work for the increases and decrease without
changing the formula each time. thanks....

 

[Myrna Larson]

As JE said, you copy the formula down the column. If you don't know how to do
that, please see Excel's Help.