26th April 2006, 03:47 PM
|
|
Member
|
|
Join Date: Jan 1970
Posts: 578
|
|
Quote:
|
Originally Posted by Twodogs
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
|
Try this: =IF(A1<2.5,IF(B1>=22,IF(B1<=35.3,IF(C1>0,1,0)),0),0)
I've done a quick test & it appears to work OK. No need for the AND statement. Best of luck. |