Trouble with If Then Equation that has multiple steps.

[NakedAngler]

I'm trying to create an If Then equation so that depending on the value in a cell it will update the value of another cell accordingly. The formula I created doesn't work which is =IF(A86<=10,30,IF(A86<=40,IF(A86<=100,50,60))).

If cell A86 is less then or equal to 10 then Cell F23 generates the value 30% but if A86 is greater then 10 then cell F23 can generate the following values based on the value in cell A86. If cell A86 is less then or equal to 40 then Cell F23 generates the value 40%, if not then If cell A86 is less then or equal to 100 then Cell F23 generates the value 50, if not then the value in cell F23 is 60%.

Have attached our tiered pricing structure below to shed some more light on what I am doing. Total quantities of the products ordered are added up and displayed in cell A86, depending on the value in cell A86 cell F23 display either 30, 40, 50, or 60 percent.

Tier 1 – When you order 10 products or less you are able to purchase the products at 30% off of the MSRP value.
Tier 2 – When you order 40 products or less you are able to purchase the products at 40% off of the MSRP value.
Tier 3 – When you order 100 products or less you are able to purchase the products at 50% off of the MSRP value.
Tier 4 – When you order 101 products or more you are able to purchase the products at 60% off of the MSRP value.

[daffodil11]

You were so close!

=if(a86<=10,30,if(a86<=40,40,if(a86<=100,50,60)))

If you want to be really fancy, you could even do:

=TEXT(IF(A86<=10,30%,IF(A86<=40,40%,IF(A86<=100,50%,60%))),"00%")

[newdoverman]

An alternative to using nested IF statements:

Please Login or Register  to view this content.

If you want the % sign:

Please Login or Register  to view this content.

OR

Please Login or Register  to view this content.

formatted as Percentage.