Hello, I think I'm looking for an if and or statement nested. This is what I'm looking for if s2 = yes and t2,u2 or v2 is blank then return 1.

You say you want a 1 if those conditions are met, but you don't say what you want if they're not. This formula will result in a Blank cell if the conditions are not met.

=IF(AND(S2="Yes",OR(T2="",U2="",V2="")),1,"")

Thank you very much!!! That's wonderful

Ask Your Question

Weekly Poll