Trying to finalize consignment calculator with tiered rates

Is the attached example what you wanted (see new attachment in post #6)?

Hey Croweater! - Yes it works!!! The labels are there and the formula is hidden! We researched online as well and found out how we can lock the columns so that no one can change the formulas. This is so once we send out the link to the google sheets site, someone cant go in there and mess with your formula.

Im not sure if something happened in the formula, but now regardless if there is anything in the Enter Item Price column, the payout is $3. In G9 there was a 3 and we changed it to a 1 which fixed the payout making it $0. But in order to get the $3 flat fee, we had to add -3 in H9. This caused the payout column to have a -$3 regardless if there is anything entered in the 'Enter Item Price' fields.
Essentially, if there is no data in Column O9:14, the total payout shows $-3. So for example if someone only has one item that is worth $10, it will calculate -$3 but the rows below show -$3 as well, so it actually deletes their entire payout when he looks at the total.

We made some progress with the 1.0 in G9 but retracted that by adding the -3 in H9. Any thoughts on getting the Payout to show $0 all the way down and only calculate if an 'Item Price' is entered in the adjacent field?

See attached - Comments added! Appreciate your help on these last few hurdles! Also, do we need the $999,999 in A18 or can it be deleted or hidden. We weren't sure if it was part of the formula.