Hi. Hope somebody can help on this as my brain cells are fried!!
My son (age 13!) is trying to do a spreadsheet. He is planning a concert, and needs to work out costs etc.
The info sheet says you need 1 bar per 500 tickets sold, with a £250 concession per bar. We have got as far as "number of tickets sold, divided by 500, multiplied by 250" to get the number of bar's required, but what if only 100 tickets were sold? you would still need one bar, but the formula I have put in won't give me a minimum value of £250. Help please. Thanks x
Hi Thanks for that. I think the point of the £250 concession comes into play when trying to work out the "break even" point. We are using >tools>goal seek to find the break even point, but it's not working yet. Still trying!!!