26th April 2006, 02:36 PM
|
Member
|
|
Join Date: Jan 1970
Posts: 221
|
|
Howdy La Mer
I have 3 columns with data in and a fourth I want to put either 1 or 0 in if the other 3 columns have all got the the correct data I am after.
I am looking for the following in the 3 columns
column 1 must be less than 2.5
column 2 must be between 22 and 35.3
column 3 must be greater than 0
If all agree I get a 1 in column 4 if not 0
Twodogs
|