Need formula for comparing differences of two columns. [Solved/Closed]

oduana777 7 Posts Thursday January 12, 2017Registration date March 23, 2017 Last seen - Jan 12, 2017 at 05:15 PM - Latest reply: oduana777 7 Posts Thursday January 12, 2017Registration date March 23, 2017 Last seen
- Feb 4, 2017 at 05:21 PM
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!
See more 

3 replies

Mazzaropi 1834 Posts Monday August 16, 2010Registration dateContributorStatus May 30, 2018 Last seen - Jan 12, 2017 at 08:58 PM
0
Thank you
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.
voniej 3 Posts Friday January 13, 2017Registration date January 16, 2017 Last seen - Jan 13, 2017 at 10:13 AM
0
Thank you
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.
oduana777 7 Posts Thursday January 12, 2017Registration date March 23, 2017 Last seen - Feb 4, 2017 at 05:21 PM
0
Thank you
Thanks! Problem solved.