Using IF AND and OR using multiple cells as reference

[vpar7493]

Hi There!

How can make the following work using the IF, AND and OR Functions:

1. getting a result "yes" or "n/a"

aa2 = will automatically display "n/a" if K2 will display the word "yes", if not, will just leave it blank.
ab2 = will automatically display "n/a" if K2 will display the word "yes", if not, will just leave it blank.
ac2 = will automatically display "n/a" if K2 will display the word "yes", if not, will just leave it blank.
ad2 = will automatically display "n/a" if any OR all or H2, I2 and J2 would display the word "yes".

2. Q2 = will display "n/a" if A2 displays the word "single"

3. AK2 = will display "Fit to Work Clearance" if T2 contains the text "class c" in the cell (but with other word in the cell like "pending class c" or "class c - ua"

I know this is a lot for one set of questions. I'm just experimenting on IF(OR(AND functions but usuall fail especially on Question #1.

Thank you so much!

 

[njimack]

Welcome to the board.

AA2: =IF(K2="yes","n/a","")
AB2: =IF(K2="yes","n/a","")
AC2: =IF(K2="yes","n/a","")
AD2: =IF(COUNTIF(H2:J2,"yes"),"n/a","")

Q2: =IF(A2="single","n/a","")

AK2: =IF(ISNUMBER(SEARCH("class c",T2)),"Fit to Work Clearance","")

 

[jasonb75]

Your chosen functions are not really suitable for your requirement.

Try

1. AA2,AB2 and AC2 =IF(K2="yes","n/a","")
AD2 =IF(COUNTIF(H2:J2,"yes"),"n/a","")

2. Same format as first formula above, =IF(Q2="single","n/a","")

3. =IF(ISNUMBER(SEARCH("class c",T2)),"Fit to work","")