Hello -

I am trying to do a pricing worksheet that is based off of three different cost scenarios. Depending on the values of two variables (B6 -> Budget & B7 -> Volume), one of the three cost scenarios is applied and each scenario is tiered based on the variables. I can get this to work across three separate cells and each of the formulas below work individually, however, I'd like to combine this into one cell for ease of use/end user clarity. Is the below situation possible?

Cost Scenario 1
- Use only if B7 is between 50 and 125, and B6 is less than 5,000
- IF(B7>='Management - Fee Based'!A19,B7/'Management - Fee Based'!K19,IF(B7>'Management - Fee Based'!A20,B7/'Management - Fee Based'!K20,IF(B7>'Management - Fee Based'!A21,B7/'Management - Fee Based'!K21,IF(B7>49,B7/'Management - Fee Based'!K22,5))))

Cost Scenario 2
- Use only if B7 is greater than 125 but less than 5,000 and B6 is greater than 5,000
- IF(AND(B6>'Management - Fee Based'!A11,B7>124,B7<5000),B6/'Management - Fee Based'!K11,IF(AND(B6>'Management - Fee Based'!A12,B7>124,B7<5000),B6/'Management - Fee Based'!K12,IF(AND(B6>'Management - Fee Based'!A13,B7>124,B7<5000),B6/'Management - Fee Based'!K13,IF(AND(B6>'Management - Fee Based'!A14,B7>124,B7<5000),B6/'Management - Fee Based'!K14,IF(AND(B6>'Management - Fee Based'!A14,B7>124,B7<5000),B6/'Management - Fee Based'!K14,IF(AND(B6>'Management - Fee Based'!A15,B7>124,B7<5000),B6/'Management - Fee Based'!K15,5))))))

Cost Scenario 3
- Use only if B6 and B7 are greater than 5,000
- IF(AND(B6>5000,B7>'Management - Fee Based'!A26),B7/'Management - Fee Based'!K26,IF(AND(B6>5000,B7>'Management - Fee Based'!A27),B7/'Management - Fee Based'!K27,IF(AND(B6>5000,B7>'Management - Fee Based'!A28),B7/'Management - Fee Based'!K28,IF(AND(B6>5000,B7>'Management - Fee Based'!A29),B7/'Management - Fee Based'!K29,IF(AND(B6>5000,B7>'Management - Fee Based'!A30),B7/'Management - Fee Based'!K30,5)))))

If more information is needed, of course ask. Thank you in advance for any insight!