need one formula for % change in TY vs LY revenue

  • Thread starter Thread starter Gene
  • Start date Start date
G

Gene

I Need to know the % change of revenue $ from this year(TY) vs last year(LY)
with one formula.

I am using TY – LY / LY = % change but result is not always correct as you
can see below.

TY LY % chg
$500 $250 100.0%
-$500 -$250 100.0%
$500 -$250 -300.0%
-$500 $250 -300.0%

I have someone copy & paste many revenue numbers for TY & LY in cells. The
% change cell is a locked formula. But the result is not accurate when gains
or losses vary.

Is there one formula to get a correct % change?
as always thanks in advance!!
 
In cell C1 enter:
=(B1-A1)/ABS(A1)
and copy down:

$500.00 $250.00 -50.00%
-$500.00 -$250.00 50.00%
$500.00 -$250.00 -150.00%
-$500.00 $250.00 150.00%
 
In cell C1 enter:
=(B1-A1)/ABS(A1)
and copy down:

$500.00 $250.00 -50.00%
-$500.00 -$250.00 50.00%
$500.00 -$250.00 -150.00%
-$500.00 $250.00 150.00%
 
thank you very much!! I am always awed by the expertise and willingness to
help on this forum.

thanks again Ashish.
 
thank you very much!! I am always awed by the expertise and willingness to
help on this forum.

thanks again Ashish.
 
HELP again. Using your formula still creates an error under one condition.
If TY (D6 is a positive number and LY(E6) is negative then the result is a
negative rather than a positive.

TY 100 LY -100 result is -200% but should be +200%.
 
HELP again. Using your formula still creates an error under one condition.
If TY (D6 is a positive number and LY(E6) is negative then the result is a
negative rather than a positive.

TY 100 LY -100 result is -200% but should be +200%.
 
Back
Top