Hi there, I need some help with a formula, been trying to figure this out but can't seem to get it right (Preferably no VBA). [IMG][IMG]http://s22.postimg.org/h16iyyg5p/Tickets.jpg[/IMG][/IMG] I need to calculate the expected revenue of ticket sales. Few things to note: 1.) Ticket sales start from cheapest to most expensive so once the $200 one is sold out, the $300 tickets will be on sale next. 2.) Expected sales is 80% of the total number of tickets. Is there a way to calculate this via a single formula? So if my expected sales of 225 (Event A), it would count up till the $700 price point with 4 tickets sold at said price point. Hence, expected revenue would be tickets sold (number) x price it was sold at ($). Any ideas? Any help would be much appreciated!
This question generated 8 answers. To proceed to the answers, click here.
This thread is current as of October 26, 2014.