A VLOOKUP table might be a possibility if the mark ups can be defined by
price bands
e.g up to $10 mark up is x%, up to $50, mark up is y% etc.

Does this fit your requirement?

"Patrick" wrote:

I am trying to create a formula which will recognize the amount of a part and
mark it up according to the mark up table I create. For instance, I would
like a .50 part marked up to $1.50 automatically by entering it in the table.
I would like a $10.00 part to be marked up to $20.00 dollars. I have approx
35 lines ranging from a part that costs .01 to parts that cost $5,000.00. I
would like to graduate the markup from a multiplier of 6.0 to a multiplier of
1.2. Does anyone have any suggestions?