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
 

Some videos you may like

Excel Facts

Square and cube roots
The =SQRT(25) is a square root. For a cube root, use =125^(1/3). For a fourth root, use =625^(1/4).

Oaktree

MrExcel MVP
Joined
Jun 20, 2002
Messages
7,984
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
7,984
Make sure W9 isn't formatted as text. Then, put everything after (and including) the = sign into W9.
 

Watch MrExcel Video

Forum statistics

Threads
1,108,492
Messages
5,523,260
Members
409,506
Latest member
reneekeane

This Week's Hot Topics

Top