Costing Worksheet

[CandiC]

I am trying to create a costing worksheet for our service department. I have
several instances for markup rates that I would need to add into a drop down
box or have the calculation set up in a macro or something. For instance, for
the parts mark up we have a tierred mark up :

0-$50 the markup is 2.5%
51-100 the markup is 2.0
101-151 the markup is 1.5

So when we enter our cost in one field, I would like the correct markup to
calculate in a separate field or have a drop box to select the most accurate
mark up rate.

Can someone help please?

 

[Gord Dibben]

For a total of cost entered in B1 plus markup.

In C1 enter this formula

=LOOKUP(B1,{0,51,101,152},{0.025,0.02,0.015})*B1+B1


Gord Dibben MS Excel MVP