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

#### ASNGW01

##### New Member
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>

### Excel Facts

Is there a shortcut key for strikethrough?
Ctrl+S is used for Save. Ctrl+5 is used for Strikethrough. Why Ctrl+5? When you use hashmarks to count |||| is 4, strike through to mean 5.
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.

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.

Replies
1
Views
1K
Replies
8
Views
529
Replies
1
Views
573
Replies
3
Views
529
Replies
3
Views
1K

Threads
1,219,691
Messages
6,149,749
Members
450,911
Latest member
williamsisland

### We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

### Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

### Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

### Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

### Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back