AND OR IF Statments

[Guest]

I've created three cells that the user will select YES or NO. I want to
create a formula that will calculate a sales commission for all three months
if any of the cells YES. I can't seem to get it to work..Any suggestions?

 

[Bernard Liengme]

This formula
=(COUNTIF(B11,"yes")>1)*A1*5%
computes 5% of A1 if any one of the cells B1,c1 or D1 contains "yes" (not
case sensitive)
Any help?
best wishes

 

[Guest]

That did help. I was able to tweek it, but I got it too work! Thank you!

 

[Guest]

Rogie:

Slight adjustment to the formula provided by Bernard:

=(COUNTIF(B11,"yes")>1)*A1*5%

it should be larger than 0 not 1 (or >=1)

=(COUNTIF(B11,"yes")>0)*A1*5%