Conditional quantities for pricing sheet?
I am creating a pricing form and am stuck on a formula. In the example, the first 4 widgets cost $10. Each additional widget is after 4 widgets is $3. In the preceding cell [1-4 WIDGETS], I have a single-select dropdown of 1, 2, 3, 4, 5+ (as I need these numbers to count the number of widgets sold for another cell/formula). What I'm looking to do:
- If the number selected is 1, 2, 3, or 4, cost = $10 and widget quantity is counted per the customer's selection.
- If the number selected is 5+, cost = $10, count [1-4 WIDGETS] quantity as '4' AND execute logic that displays the next column of '[ADDITIONAL WIDGETS]' with 5, 6, 7, 8, etc..
I was going to use IFBLANK because I do not want to have a dollar value in cells that have not yet been selected (as this will mess up my totals in the summary reports).
I have a feeling that I am over-thinking this. Any thoughts?
Help Article Resources
Check out the Formula Handbook template!