Parts markup

hotncoolwolfe

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

Using Function Arguments with nested formulas
If writing INDEX in Func. Arguments, type MATCH(. Use the mouse to click inside MATCH in the formula bar. Dialog switches to MATCH.

xenou

MrExcel MVP
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,
ξ

Replies
15
Views
369
Replies
4
Views
132
Replies
1
Views
247
Replies
8
Views
134
Replies
1
Views
54

1,171,825
Messages
5,877,764
Members
433,285
Latest member
iAbdullah

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.

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

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