How to format whole column negative value, Excel

P

PES

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 customer’s
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?
 
B

Bernard Liengme

Please clarity this. We want to help, but I for one and confused
best wishes
 
O

OssieMac

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)
 
J

Jacob Skaria

Apply this formula in Column C1 '=-B1' and copy that to the entire column C

Copy entire Column B. Right Click PasteSpecial-->Values to column D.
Delete column B and column C

If this post helps click Yes
 
S

Shane Devenshire

Hi,

1. there is no SUBTRACT or DIFFERENCE function in Excel
2. I would use =A1-B1 and coping it down
3. However, you can convert all the entries in column B to negatives as
follows. In a blank cell enter -1. Select that cell and copy it. Then
select the numbers in column B and choose Edit, Paste Special, Multiply.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

negative number format 1
Negative Number column 1
Sum variable range of column entries in offset cell 5
Excel Positive/Negative Running Total 1
Changing positive values to negative 2
Excell - two conditions count if factors are true when negative nu 2
Sumproduct a column where 2 adj text columns contain same value 5
Making a Value in One Column Negative Based on Value in Another Co 1

Top