Creating a sliding scale discount

G

Guest

Hi,
I am trying to work out a formula for creating a sliding scale discount. I'm
trying to create a pricing calculator spreadsheet for a printing company. If
you buy 1 -5 copies the price is X, 6-20 copies the price is Y, 21-50 copies
the price is W and so on. What is the best way of entering a number and
returning the relevant discount amount?
Thanks
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top