if formula

[gerry]

i have two columns with number data. i want the difference between the two
columns be in the third column if the first column is greater than the second
column and on the fourth column if the first column is lesser than the
second column

 

[Mike H]

Hi,

Assuming your number in cols A&B.

This in C1
=IF(A1>B1,A1-B1,"")
This in d1
=IF(B1>A1,B1-A1,"")

Drag both down.

Mike