Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
if formula
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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
if formula
Hi,
Assuming your number in cols A&B. This in C1 =IF(A1B1,A1-B1,"") This in d1 =IF(B1A1,B1-A1,"") Drag both down. Mike "gerry" wrote: 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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|