Excel nested if and or statement

October 20, 2010 at 06:45:22
Specs: Windows Vista
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.

See More: Excel nested if and or statement

Report •

#1
October 20, 2010 at 06:54:37
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,"")


Report •

#2
October 20, 2010 at 06:58:51
Thank you very much!!! That's wonderful

Report •
Related Solutions


Ask Question