Multiple if fomula

[dunmore83]

Hi,

I need to expand the following formula in cell O10;

=IF(L10="YES",IF(O7<L14,"YES","NO"),"N/A")

to include 2 more IF criteria's;

- if cell L21 is N/A then continue the formula as above

- if cell L24 is N/A then continue the formula as above

So three IF criteria's exist for this formula to continue:
- L10 must be YES, L21 must be N/A and L24 must be N/A

On the opposite side these cells can have;

- L10 can have N/A

- L21 can have YES

- L24 can have YES

.... if any of the above is true then cell O10 must be N/A

Hope it makes sense.

Thanks so much for your help!!

 

[pgc01]

Hi

Try:

=IF(AND(L10="YES",L21="N/A",L24="N/A"),IF(O7<L14,"YES","NO"),"N/A")

 

[jasonb75]

Do the cells contain "N/A" or the formula error #N/A

 

[dunmore83]

Hi.... need some help with the following

(IT IS SIMILIAR TO THE ABOVE SCENARIO BUT A LITTLE DIFFERENT. I WAS FLAGGED FOR POSTING A DUPLICATE THREAD!)

- IF cell I11 is "YES" & cell I12 is "N/A" then cell L10 needs to execute this.... IF(L7>=F7,"NO","YES")

- IF cell I11 is "NO" then L10 is "N/A"

ALSO

- IF cell I11 is "YES" & I12 is any numerical value then L10 needs to be "N/A"

This is what i have but it's not working??!!!

=IF(AND(I11="NO",ISNUMBER(I12)),IF(L7>=F7,"NO","YES"),"N/A")

Thanks for your help!!!

 

[jasonb75]

My previous question regarding the true identity of the N/A in the cells still stands, what will work for one will not work for the other.

Does this work?

=IF(OR(AND(I11="NO",I12="N/A"),AND(I11="YES",NOT(ISNUMBER(I12)))),IF(L7>F7,"NO","YES"),"N/A")

 

[dunmore83]

Thank you!

Almost works for all conditions.

It doesn't seem to be true when I11 is NO. When I11 is NO, L10 returns YES. It should be returning N/A.

Cheers. Appreciate your help

 

[jasonb75]

Should NO (or anything except YES) always return N/A regardless of the other cells?

=IF(AND(I11="YES",OR(NOT(ISNUMBER(I12)),I12="N/A")),IF(L7>F7,"NO","YES"),"N/A")<!-- / message -->

 

[dunmore83]

Amazing! looks to be working. cheers!!

 

[dunmore83]

I have another formula i need to add another IF scenario too:

=IF(AND(L10="YES",L21="N/A",L24="N/A"),IF(O8>L14,"YES","NO"),"N/A")

This needs to be adjusted so that if L21 is "NO" this part needs to execute as above.... IF(O8>L14,"YES","NO")

So if L21 is "N/A" &/or L21 is "NO"..... IF(O8>L14,"YES","NO") executes

Apart from this formula the same.

I will get this eventually. Just confusing when there are so many if's &/ors??!!

THANK YOU!!!

 

[jasonb75]

So you want L21="NO", L10="YES", L24="N/A"

=IF(AND(L10="YES",OR(L21={"N/A","NO"}),L24="N/A"),IF(O8>L14,"YES","NO"),"N/A")

or L21="NO", L10 = anything, L24 = anything

=IF(OR(L21="NO",AND(L10="YES",L21="N/A",L24="N/A")),IF(O8>L14,"YES","NO"),"N/A")