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

When did Power Query debut in Excel?
Although it was an add-in in Excel 2010 & Excel 2013, Power Query became a part of Excel in 2016, in Data, Get & Transform Data.

Watch MrExcel Video

Forum statistics

Threads
1,113,936
Messages
5,545,104
Members
410,656
Latest member
Hydraulics
Top