|Nothing personal towards Mike's solution, but I'm not sure it works in all cases. I say this based on your stated requirements.|
You said the "The cost always rounds UP to .95"
As an example, you also said:
"If the cost of the part is equal to or more than $90, then it needs to be divided by .6"
90/.6 = 150.00
Mike's formula returns 149.95, which means it rounded down to .95.
This formula, which I pieced together from some stuff I found on the web, seems to round everything up to .95 as requested. I'm not even going to try to explain it.
This will round the result for 90 up to 150.95, which is what I believe you asked for. If you enter 1 - 100 in Column A and drag both of our formulas down, you will find that whenever the result of the calculation (*2.1 or /.6) is an integer value, Mike's solution "loses" a nickle while mine (well, not really mine) adds 95¢ to the actual result.
The correct formula to use will obviously depend on what your actual requirements are.
Click Here Before Posting Data or VBA Code ---> How To Post Data or Code.