Hello I am trying to create equation that combines tiered pricing based on utilization of a service and a low/high cost sensitivity. On top of this, I want to offer this pricing method as 1 of 3 options. The objective is to offer a client the opportunity to evaluate total revenue based on cost and pricing option sensitivities. Pricing changes as the use of the service increases. Utilization of the service is a dynamic cell that changes based on other variables and sensitivities. However, for purposes of writing this statement, it is no different than calling it cell A1. The tiering pricing is listed below. (I'll call the cells with the low/high cost values X1 and Z1, and the sensitivity option cell is AA1. Low cost is identified by the value 1, high cost is 2) 0 - 400,000 - $30 to $35 400,001 to 800,000 - $28 to $33 800,0001 to 1,200,000 - $26 to $31 >1,200,001 - $24 to $29 I've removed the pricing option sensitivity from the situation and have tried to write an if/then statement that provides me with just the price. =IF(A1<400000,IF(AA1=1,X1,Z1),IF((A1>400001)*AND(A1<800000),(IF(AA1=1,X1,Z1),IF((A1>800001)*AND(A1<1200000),(IF(AA1=1,X1,Z1),IF((A1>1200001),(IF(AA1=2,X1,Z1))),0) I want to be able to add another IF statement before this whole thing to include the pricing option and then multiply the entire statement by the actual value in A1. I think I could use a CHOOSE and MATCH combo, but I am not all that familiar with either. Any help is appreciated.