Calculating percentages

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
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....
 
As JE said, you copy the formula down the column. If you don't know how to do
that, please see Excel's Help.
 
Back
Top