Thanks La Mer

Just looking at it now. Might be able to use that as well.

Beauty
Twodogs

Any hints for if I want within that formula to say Q7>22 and less than 35.

=IF(AND(O7<2.5,Q7>22OR<35.2,U7>0),1,0) wouldn't work would it??

Twodogs

=IF(AND(O7<2.5,((Q7>22)*OR(Q7<35.2,))*U7>0),1,0)
This seems to work but it was a solution offered by excel itself. I don't understand how it works. Can someone explain please?

Thanks
Twodogs

What exactly are you attempting to achieve 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.

Thanks La Mer

The other formula I posted works but I would rather understand how it works.Will have a play thanks for your help today La Mer

Twodogs