Need formula for comparing differences of two columns.

Solved/Closed
oduana777 Posts 7 Registration date Thursday January 12, 2017 Status Member Last seen March 23, 2017 - Jan 12, 2017 at 05:15 PM
oduana777 Posts 7 Registration date Thursday January 12, 2017 Status Member Last seen March 23, 2017 - 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!

3 responses

Mazzaropi Posts 1985 Registration date Monday August 16, 2010 Status Contributor Last seen May 24, 2023 147
Jan 12, 2017 at 08:58 PM
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.
0
voniej Posts 1 Registration date Friday January 13, 2017 Status Member Last seen January 16, 2017
Jan 13, 2017 at 10:13 AM
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.
0
oduana777 Posts 7 Registration date Thursday January 12, 2017 Status Member Last seen March 23, 2017
Feb 4, 2017 at 05:21 PM
Thanks! Problem solved.
0