Report

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

Ask a question oduana777 7Posts Thursday January 12, 2017Registration date March 23, 2017 Last seen - Last answered on Feb 4, 2017 at 05:21 PM by oduana777
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 
Helpful
+0
plus moins
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.
Leave a comment
Helpful
+0
plus moins
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.
Leave a comment
Helpful
+0
plus moins
Thanks! Problem solved.
Leave a comment

Member requests are more likely to be responded to.

Members can monitor the statuses of their requests from their account pages.

A CCM membership gives you access to additional options.

Not a member yet?

Sign up now. It takes less than a minute and is completely free!