IF, AND, OR formula help

[jrlafrance]

I'm trying to work a AND statement that also contains an OR statement as part of one of the AND statements. What I want to check for is in cell C7. If that value = "Axe-1H", and either K3, L3 or M3 = "Weapons Master (Passive)", then to return 10%, else 0, in cell R13.

I know I'm close, but just can't get the order of things correct.

Thanks in advance for any help!

[Cutter]

I haven't looked at your file but maybe:

=IF(AND(C7="Axe-1H",COUNTIF(K3:M3,"Weapons Master (Passive)")),0.1,0)

[jrlafrance]

Thanks for the help Cutter! Formula works like a charm!

[Cutter]

You're welcome.