Data Validation in Google Sheets

[cayde716]

So I am selling tickets for a raffle and trying to make this as easy as possible. The tickets that I'm selling are 1 for $5, 3 for $10, 7 for $20. I was able to make a date validation drop down for the amount of tickets purchased but I am trying to make it so it auto populates the price. Is there a way to do that in sheets?

 

[Fluff]

Will the tickets only ever be 1,3 or 7, or could someone buy 4 tickets?

 

[cayde716]

Will the tickets only ever be 1,3 or 7, or could someone buy 4 tickets?

They could but for that i would just add a new sale if that makes sense.

 

[Fluff]

In that case how about

=switch(B2,1,5,3,10,7,20)

 

[cayde716]

In that case how about

=switch(B2,1,5,3,10,7,20)

this is perfect. Thank you so much!!

 

[Fluff]

You're welcome & thanks for the feedback.