# Formula help

#### Cstubbe97

##### New Member
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

### 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.

#### Eric W

##### MrExcel MVP
Welcome to the forum!

Try:

=ROUNDUP(A1*5/3,0)

Replies
1
Views
45
Replies
5
Views
309
Replies
11
Views
467
Replies
1
Views
213
Replies
0
Views
189