Formula for Negative Values - ?

[Learningfast]

What do I place in the variance column so negatives are subtracted in the
whole column regardless of whether my sales are negative this year or last?
Thanks
Sales ($) Sales ($) LY Variance
60.14 (66.00)
0.00 0.00
155.45 0.00
118.43 0.00
0.00 132.82
0.00 0.91
0.00 0.00
(241.99) 565.31

 

[RagDyeR]

Don't quite follow what you're asking.

Do either of these, copied down, work for you:

=ABS(A2-B2)

OR

=ABS(MAX(A2,B2))-ABS(MIN(A2,B2))
--

HTH,

RD
=====================================================
Please keep all correspondence within the Group, so all may benefit!
=====================================================


What do I place in the variance column so negatives are subtracted in the
whole column regardless of whether my sales are negative this year or last?
Thanks
Sales ($) Sales ($) LY Variance
60.14 (66.00)
0.00 0.00
155.45 0.00
118.43 0.00
0.00 132.82
0.00 0.91
0.00 0.00
(241.99) 565.31