Formula for Negative Values - ?
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!
================================================== ===
"Learningfast" wrote in message
...
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
|