i'm trying to develop a formula that helps me mark up parts based on the price range of the part. For example:
a) part 1- in cell 1a $.01-$5.00 (parts falling within this range would have a multiplier of 5--- and put that value in cell A10
b) part 1- in cell 1a $5.01-$30.00 (parts falling...