Trying to get Minimum Price if Price Doesn't hit a Threshold, but Minimum Price is based off of value in another cell

[ASNGW01]

I'm trying to show a minimum value if said value doesn't hit a threshold. However, the threshold changes by a value in another cell. Thank you so much!!!

=IF(C86=$J$87,IF(B86="",0,IF(B86<=30000,IF((B86<$L$97,$L$97,B86),IF(AND(B86>30000,B86<=60000),IF(B86<$L$98,$L$98,B86),IF(AND(B86>60000,B86<=100000),IF(B86<$L$99,$L$99,B86),IF(C86=$J$86,IF(B86="",0,IF(B86<=30000,IF(B86<$L$102,$L$102,B86),IF(AND(B86>30000,B86<=60000),IF(B86<$L$103,$L$103,B86),IF(AND(B86>60000,B86<=100000),IF(B86<$L$104,$L$104,B86),B86)))))))))))

The First Threshold is:

$30K or less	$10,000
$31-$60k	$15,000
$61k-$100k	$25,000

<colgroup><col><col></colgroup><tbody>
</tbody>

The second Threshold is:

$30K or less	$7,500
$31-$60k	$10,000
$61k-$100k	$15,000

<colgroup><col><col></colgroup><tbody>
</tbody>

 

[WarPigl3t]

No one will reply if you don't label your columns in the table. Column A, B ,c. Label the rows. Row 1,2,3. Designate were the output goes. And provide sample data. No one wants to look at a formula that doesn't work and try to figure out what it means.

 

[ASNGW01]

No one will reply if you don't label your columns in the table. Column A, B ,c. Label the rows. Row 1,2,3. Designate were the output goes. And provide sample data. No one wants to look at a formula that doesn't work and try to figure out what it means.

My Bad, thanks for the input.