Combine Conditions using OR

Return a result when any one of several conditions is met.

You will learn to

• Use OR inside IF

How it works

OR returns TRUE if at least one condition is TRUE: =IF(OR(B2>=10,C2>=2000),"VIP","Standard").

OR is most useful inside IF: =IF(OR(B2>=90,C2="Yes"),"Bonus","No bonus") pays the bonus when either condition holds. Use AND instead when every condition must be true.

=IF(OR(B2>=10,C2>=2000),"VIP","Standard")