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?