# Mark up by percentage

#### BKrakowski

##### New Member
I have a cost of a part in Cell V9.

I want to mark it up depending on the cost of the part as follows:

\$1.00 to \$200.00 = 49%
\$201.00 to \$300.00 = 45%
\$301.00 to \$400.00 = 40%
\$400.00 to 500.00 = 35%
\$500.00 and up = 32%

I want the end result - Cost plus the mark up to end up as a sell price in Cell W9.

Any suggestions??

Thanks,
Barbara

### Excel Facts

What did Pito Salas invent?
Pito Salas, working for Lotus, popularized what would become to be pivot tables. It was released as Lotus Improv in 1989.
W9=V9*(1+LOOKUP(V9,{1,0.49;201,0.45;301,0.4;401,0.35;501,0.32}))

Do I just insert this into cell W9? I tried and it just gave me what I typed, not an actual formula calculation

Make sure W9 isn't formatted as text. Then, put everything after (and including) the = sign into W9.

It worked, thanks so much for your help!!
Barbara

Replies
2
Views
481
Replies
2
Views
87
Replies
3
Views
199
Replies
4
Views
175
Replies
3
Views
293

1,219,960
Messages
6,151,166
Members
451,012
Latest member
OH650R

### 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.

### Which adblocker are you using?

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