Mark up by percentage

BKrakowski

New Member
Joined
Mar 11, 2005
Messages
29
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

Control Word Wrap
Press Alt+Enter to move to a new row in a cell. Lets you control where the words wrap.

Oaktree

MrExcel MVP
Joined
Jun 20, 2002
Messages
8,016
Office Version
  1. 365
W9=V9*(1+LOOKUP(V9,{1,0.49;201,0.45;301,0.4;401,0.35;501,0.32}))
 

BKrakowski

New Member
Joined
Mar 11, 2005
Messages
29
Do I just insert this into cell W9? I tried and it just gave me what I typed, not an actual formula calculation
 

Oaktree

MrExcel MVP
Joined
Jun 20, 2002
Messages
8,016
Office Version
  1. 365
Make sure W9 isn't formatted as text. Then, put everything after (and including) the = sign into W9.
 

Forum statistics

Threads
1,141,588
Messages
5,707,264
Members
421,498
Latest member
matinebi

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