Multiple IF Statement

[wizardmagu]

I have an IF formula I am trying to get worked out but am having a challenge with it giving me what I need

Column C can be CASED or TOTE and column D can be 0, 1, 2, 3. I want to return "Yes" when any of the following are TRUE

Column C = "Tote" and Column D is 1
Column C = "Cased" and Column D is 2
Column C = "Cased" and Column D is 3

This is the formula I am trying but not sure what I am doing with the OR and AND statement

=IF(OR(AND(C12="TOTE",D12=1),AND(C12="Cased",D12=2),AND(,C12="Cased",D12=3)),"Yes","No")

 

[Ottsel]

=IF((AND(C12="Tote",D12=1)),"Yes",IF((AND(C12="Cased",D12=2)),"Yes",IF((AND(C12="Cased",D12=3)),"Yes","")))

 

[wizardmagu]

Thanks for the help.

 

[Ottsel]

Thanks for the help.

Happy to help!