G
Guest
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
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