hotncoolwolfe

New Member
Joined
Feb 10, 2010
Messages
1
i'm trying to develop a formula that helps me mark up parts based on the price range of the part. For example:

a) part 1- in cell 1a $.01-$5.00 (parts falling within this range would have a multiplier of 5--- and put that value in cell A10
b) part 1- in cell 1a $5.01-$30.00 (parts falling within this range would have a multiplier of 4---and put that value in cell A10
c) part 1- in cell 1a $30.01-$50.00 (parts falling within this range would have a multilplier of 3 ---and so on

i have 7 ranges total..just need to know how to write the formula and i can replicate for each range and multiplier.
 

Excel Facts

How to fill five years of quarters?
Type 1Q-2023 in a cell. Grab the fill handle and drag down or right. After 4Q-2023, Excel will jump to 1Q-2024. Dash can be any character.

xenou

MrExcel MVP
Joined
Mar 2, 2007
Messages
16,836
Office Version
  1. 2019
Platform
  1. Windows
Did you solve your problem? This might be a good candidate for creating a small lookup table of your markup multipliers and prices, then using VLOOKUP() on the lookup table. Could you provide a small sample of two or three rows with the cell values and expected results?

Note: Cell 1a is not a valid cell reference so I'm not understanding that part of your question. Do the multipliers continue down to 1? Can you give the complete set of values?

Cheers,
ξ
 

Forum statistics

Threads
1,136,333
Messages
5,675,175
Members
419,552
Latest member
jsanjur

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

Which adblocker are you using?

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
Top