Formula to Calculate Tiered Pricing

10 items free??!!!

Yes, the first 10 are free.

Try

=IF(A1<11,0,IF(A1<=20,(A1-10)*0.25,(A1-20)*0.5+2.5))

A1=Quantity

so A1=25

=10*0.25+5*0.5 is 2.5+5*0.5

Thanks John,

That is exactly what I was looking for. I really appreciate your help!

You are very welcome.

If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED. Thanks.

Hoping someone can help with this Tiered pricing:

<$1mm=15 basis points
$1mm to $5mm=11 basis points
$5mm to $10mm= 9 basis points
$10mm+ = 6 basis point

Unfortunately your post does not comply with Rule 2 of our Forum RULES. Do not post a question in the thread of another member -- start your own thread.

If you feel an existing thread is particularly relevant to your need, provide a link to the other thread in your new thread.

Old threads are often only monitored by the original participants. New threads not only open you up to all possible participants again, they typically get faster response, too.