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?