We are a shirt printing company and use Excel with formulas to quote prices to our clients. I want to make the quoting system more simple and add in some functions that will automatically choose the correct prices.
With the way our quote works we have several options to choose, from how many colours, how many screens and how many shirts.
I need the formula to select the right price depending on the shirt qty and amount of colours selected.
If you want 60 shirts with 1 colour the price will be $1.35 per shirt for the ink.
But if you want 40 shirts with 1 colour the price will be $1.65 per shirt
Or if you got 60 shirts with 3 colours the price will be $1.80 per shirt for the ink.
The ink quantities range between 0-12, the shirt qualities use price brackets like:
1-25 shirts equals $xx price
51-125 etc all the way to 5000+ shirts
So I would need a formula that could choose the right price based depending on two different options (quantity of shirts and quantity of colours)
I already have the template made, I just need the formulas added in, any questions please let me know. Thanks!