if formula

  • Thread starter Thread starter gerry
  • Start date Start date
G

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
 
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
 
Back
Top