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
1854
Registration date
Monday August 16, 2010
Status
Contributor
Last seen
December 4, 2020
136
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.

Subscribe To Our Newsletter!

The Best of CCM in Your Inbox

Subscribe To Our Newsletter!