Need formula for comparing differences of two columns.

Solved/Closed
Report
Posts
7
Registration date
Thursday January 12, 2017
Status
Member
Last seen
March 23, 2017
-
Posts
7
Registration date
Thursday January 12, 2017
Status
Member
Last seen
March 23, 2017
-
Column A and B both contain numeric values. I want Excel to look at both and give me the numeric difference between the two in a new column C. I realize that if B is subtracted from A I may get a positive value or a negative value depending on which number is larger or a match as both values in that particular row of both columns A and B is the same.
What is the exact formula and how do I enter it to my spreadsheet.

Thanks!

3 replies

Posts
1947
Registration date
Monday August 16, 2010
Status
Contributor
Last seen
November 11, 2021
147
oduana777, Good evening.

I'm not sure if I understood well your necessity.

Try to use:

C1 --> =A1-B1

Copy this formula down.

Is that what you want?
I hope it helps.
Posts
3
Registration date
Friday January 13, 2017
Status
Member
Last seen
January 16, 2017

You could use either:
=C6<>D6
or
=IF(C6<>D6,"","Diff")

The first: place the formula in column E. It will show either a true or false in the fields as you copy it down

The second: will show 'Diff' only if the two cells do not match.

Hope this helps.
Posts
7
Registration date
Thursday January 12, 2017
Status
Member
Last seen
March 23, 2017

Thanks! Problem solved.