| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
complex IF statement
Hello.
In cell $E$70 I have a data validation drop down list which allows the user to select a percentage between 0% and 10%. I am trying to get cell $D$70 to read "Product Subtotal at 1% discount" when cell $E$70 is 1%, "Product Subtotal at 2% discount" when cell $E$70 is 2%" etc. I tried using an IF statement, however as you know, it caps out at 7 IF arguments. I need 10 arguments and then just "Product Subtotal" when 0% is selected. Does anyone know how to get around the 7 argument problem? Thanks in advance -- Cathy |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
complex IF statement
You can use concatenation with only one IF like this:
="Product Subtotal"&IF($E$700," at "&$E$70*100&"% discount","") "cathy" wrote in message ... Hello. In cell $E$70 I have a data validation drop down list which allows the user to select a percentage between 0% and 10%. I am trying to get cell $D$70 to read "Product Subtotal at 1% discount" when cell $E$70 is 1%, "Product Subtotal at 2% discount" when cell $E$70 is 2%" etc. I tried using an IF statement, however as you know, it caps out at 7 IF arguments. I need 10 arguments and then just "Product Subtotal" when 0% is selected. Does anyone know how to get around the 7 argument problem? Thanks in advance -- Cathy |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
complex IF statement
One way:
D70: ="Product Subtotal at " & TEXT($E$70,"0%") & " discount" In article , cathy wrote: Hello. In cell $E$70 I have a data validation drop down list which allows the user to select a percentage between 0% and 10%. I am trying to get cell $D$70 to read "Product Subtotal at 1% discount" when cell $E$70 is 1%, "Product Subtotal at 2% discount" when cell $E$70 is 2%" etc. I tried using an IF statement, however as you know, it caps out at 7 IF arguments. I need 10 arguments and then just "Product Subtotal" when 0% is selected. Does anyone know how to get around the 7 argument problem? Thanks in advance |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
complex IF statement
Both answers were VERY helpful!!! I wound up using this one. It worked
GREAT!!! Thanks so much -- Cathy "Alain Vaillancourt" wrote: You can use concatenation with only one IF like this: ="Product Subtotal"&IF($E$700," at "&$E$70*100&"% discount","") "cathy" wrote in message ... Hello. In cell $E$70 I have a data validation drop down list which allows the user to select a percentage between 0% and 10%. I am trying to get cell $D$70 to read "Product Subtotal at 1% discount" when cell $E$70 is 1%, "Product Subtotal at 2% discount" when cell $E$70 is 2%" etc. I tried using an IF statement, however as you know, it caps out at 7 IF arguments. I need 10 arguments and then just "Product Subtotal" when 0% is selected. Does anyone know how to get around the 7 argument problem? Thanks in advance -- Cathy |
|
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
complex IF statement
That's Great. Thanks so much
-- Cathy "JE McGimpsey" wrote: One way: D70: ="Product Subtotal at " & TEXT($E$70,"0%") & " discount" In article , cathy wrote: Hello. In cell $E$70 I have a data validation drop down list which allows the user to select a percentage between 0% and 10%. I am trying to get cell $D$70 to read "Product Subtotal at 1% discount" when cell $E$70 is 1%, "Product Subtotal at 2% discount" when cell $E$70 is 2%" etc. I tried using an IF statement, however as you know, it caps out at 7 IF arguments. I need 10 arguments and then just "Product Subtotal" when 0% is selected. Does anyone know how to get around the 7 argument problem? Thanks in advance |
|
#6
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
complex IF statement
Using the TEXT function would work great too using it that way:
="Product Subtotal"&IF($E$700," at "&TEXT($E$70,"0%")&" discount","") "cathy" wrote in message ... Both answers were VERY helpful!!! I wound up using this one. It worked GREAT!!! Thanks so much -- Cathy "Alain Vaillancourt" wrote: You can use concatenation with only one IF like this: ="Product Subtotal"&IF($E$700," at "&$E$70*100&"% discount","") "cathy" wrote in message ... Hello. In cell $E$70 I have a data validation drop down list which allows the user to select a percentage between 0% and 10%. I am trying to get cell $D$70 to read "Product Subtotal at 1% discount" when cell $E$70 is 1%, "Product Subtotal at 2% discount" when cell $E$70 is 2%" etc. I tried using an IF statement, however as you know, it caps out at 7 IF arguments. I need 10 arguments and then just "Product Subtotal" when 0% is selected. Does anyone know how to get around the 7 argument problem? Thanks in advance -- Cathy |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Complex IF Statement | Excel Discussion (Misc queries) | |||
| Complex IF THEN statement | Excel Worksheet Functions | |||
| Complex If/And Statement | Excel Worksheet Functions | |||
| Help with complex If statement | Excel Worksheet Functions | |||
| complex IF(OR(...AND())) statement | Excel Discussion (Misc queries) | |||
Linear Mode
