what is the formula for calculating pertcentages of sales from mo.

[tssjhs]

Help.. Need to calculate percentage of sales growth or decline from month to
month. 12/31/2004 % Change # 1/31/2005
$308,902,200 #VALUE! $250,870,126
$250,984,061
$408,321,745
Multiple tracking, how do I create a formula to accept ABS when the absolute
value of the first number could be <or >.

 

[Gary Brown]

(Jan - Dec)/Dec
HTH,
Gary Brown

 

[Gary Brown]

If January IS less than December, you WANT to have a negative number as a
change, however, I think you want...
ABS((Jan - Dec) / Dec)
HTH,
Gary Brown