How to format whole column negative value, Excel
Do you mean that you just want the difference between A and B and return that
as a positive number irrespective of whether A or B is the larger value? If
so then you can use the following:-
=ABS(A2-B2)
--
Regards,
OssieMac
"PES" wrote:
I want to make a whole column negative currency value so that the sum of
A+B=Difference. This is to remove the entries in B from the customers
responsibility.
Or should one just use the formula, =A-B, and format the appearance of the
remainder column?
Am I correct: that Excel does not have a function for DIFFerence or
SUBTraction?
|