Trying to finalize consignment calculator with tiered rates

1. A slight mod to the formula in P9 (drag down). This should fix up your problems with both a $1 flat fee and a blank item price.

=IF($O9="","",IF($R9>=1,$R9,$R9*$O9+$S9))

2. Yes. You can get rid of the amount in A18. It should still work.

Let me know if this fixes everything up.