Combine Conditions using AND

Require several things to be true at once inside an IF.

You will learn to

• Use AND to combine tests
• Nest AND inside IF

How it works

AND returns TRUE only when every condition is TRUE. Combine it with IF to test several requirements: =IF(AND(B2>=5,C2="Yes"),"Yes","No").

=IF(AND(B2>=5,C2="Yes"),"Yes","No")