Expert: Nathan Head - 9/30/2009

Question
HELLO Sir,I have a list of numeric values in columnA and columnB.I need to compare the values of columnA to columnB and put the difference between them in columnC.

example:
col.A   col.B  col.C
3         4     1
3         3     0
6         7     1
9         8     1
5         5     0

Answer
solayman.inty:

I will presume the above values are in cells A1:B5.

Place this formula in cell C1:

=ABS(A1-B1)

Copy the formula down from C1 through C5.  ABS is the Excel function for absolute value (which appears to be what you need since it appears you need the difference with no regard to if the difference is positive or negative.