If meets criteria in multiple columns then place "X"

**ajeffres** · 05-21-2014, 12:27 PM

What I'm trying to do is make a formula for U8 on the individual site sheets (Arcadia Public Schools, Bank of Broken Bow, etc) that will automatically put an X if ANY of the following conditions are met:

Column K has an X
Column L has an X
Column O is >240
Column P is a female < 50 or a male < 40
Column Q is > 200
Column R is > 160
Column S is fasting and >=100
Column T is <0.9 or >5

**Miraun** · 05-21-2014, 12:49 PM

In U8, try the following:
IF(OR(K8="X",L8="X",O8>240,AND(B8="Male",P8<40),AND(B8="Female",P8<50),Q8>200,R8>160,AND(N8="Yes",S8>=100),T8<0.9,T8>5),"X","")

**ajeffres** · 05-21-2014, 02:15 PM

Perfect!! Thank you!!

**ajeffres** · 05-21-2014, 04:20 PM

Actually, something doesn't seem to be quite right with the formula the more I test it. Any other help?

Also, can I add if Column P or Q are N/A it should be marked with an X.