Mark up by percentage

[BKrakowski]

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

 

[Oaktree]

W9=V9*(1+LOOKUP(V9,{1,0.49;201,0.45;301,0.4;401,0.35;501,0.32}))

 

[BKrakowski]

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

 

[Oaktree]

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

 

[BKrakowski]

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