| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
AND OR IF Statments
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? |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
AND OR IF Statments
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? |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
AND OR IF Statments
That did help. I was able to tweek it, but I got it too work! Thank you!
"Bernard Liengme" wrote: 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? |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
AND OR IF Statments
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% -- Hope this helps Martin Fishlock, Bangkok, Thailand Please do not forget to rate this reply. "Rogie" wrote: That did help. I was able to tweek it, but I got it too work! Thank you! "Bernard Liengme" wrote: 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? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| LONG IF (diff columns) STATMENT(s) | Excel Worksheet Functions | |||
| If Statments containing letters | Excel Discussion (Misc queries) | |||
| Conditional statments. | Excel Discussion (Misc queries) | |||
| IF statments for multiple listings. | Excel Worksheet Functions | |||
| Is there an Excel template to reconcile business bank statments? | Excel Discussion (Misc queries) | |||
Linear Mode
