So I have a scenario I’m trying to formulate into excel. Ex. I have a sum of tickets created at the bottom of my column. Raffle tickets are 3 for five dollars or 2 dollars each I have a sum for amount of tickets being purchased.
So, if someone wanted 2 tickets it would respectively say, $ 4.00 but as soon as that turned to three it would give a discount of 1.00 and so on thereafter. If they wanted 6 tickets it’d be further discounted by two dollars
So 3 tickets = 5.00 6 = 10.00 9 = 15 and so on. But individually they are 2.00 so 4 tickets would be 7.00 etc. How would I formulate this to create a sum owing to the purchaser? With discounts applied. Every third save a $1.00
So, if someone wanted 2 tickets it would respectively say, $ 4.00 but as soon as that turned to three it would give a discount of 1.00 and so on thereafter. If they wanted 6 tickets it’d be further discounted by two dollars
So 3 tickets = 5.00 6 = 10.00 9 = 15 and so on. But individually they are 2.00 so 4 tickets would be 7.00 etc. How would I formulate this to create a sum owing to the purchaser? With discounts applied. Every third save a $1.00