Formula help

Cstubbe97

New Member
Joined
Oct 6, 2020
Messages
1
Office Version
  1. 365
Platform
  1. Windows
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
 

Some videos you may like

Excel Facts

Shade all formula cells
To shade all formula cells: Home, Find & Select, Formulas to select all formulas. Then apply a light fill color.

Watch MrExcel Video

Forum statistics

Threads
1,112,995
Messages
5,543,183
Members
410,584
Latest member
Bluefox68
Top