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....


"JE McGimpsey" wrote:

one way:

B2: =C2/A2 - 1

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

In article ,
tssjhs wrote:

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

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

On Tue, 25 Jan 2005 05:29:03 -0800, tssjhs
wrote:

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....


"JE McGimpsey" wrote:

one way:

B2: =C2/A2 - 1

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

In article ,
tssjhs wrote:

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