View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.newusers
OssieMac OssieMac is offline
external usenet poster
 
Posts: 2,510
Default 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?