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

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

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

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

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

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