AND OR IF Statments

R

Rogie

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?
 
B

Bernard Liengme

This formula
=(COUNTIF(B1:D1,"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
 
M

Martin Fishlock

Rogie:

Slight adjustment to the formula provided by Bernard:

=(COUNTIF(B1:D1,"yes")>1)*A1*5%

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

=(COUNTIF(B1:D1,"yes")>0)*A1*5%
 
Top