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
--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email
"Rogie" wrote in message
...
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?