Coursework HELP Please!!!

Hello Everyone;


Sorry to disturb you all but I have an issue with excel;


I'm required to created a booking system for my coursework, and I don't know how to create a macro or if statement that will allow the system to stop over bookings.

There are three price bands, four concession ticket charges, 200 seats and three zones. Top zone = 50 seats available, middle zone = 70 seats and standard zone = 80 seats. Customers can only book a ticket for one production at a time but they also need to select one zone they would like to sit within.

How do I create a macro or if statement that would allow me to do this


Please help!!!

Hello Airline_101,

Welcome to the Forum!

The rule here for helping with coursework or homework is to provide guiding assistance only. That means we will help answer specific questions but not do the work for you.

Hi, welcome to the forum

As mentioned, you need to do the work, we will help and guide. What have you done so far?

Also, Please take a moment to read the forum rules and then amend your thread title to something descriptive of your problem - not what you think the answer might be. (think google search terms?). Once you have done this please send me a PM and I will remove this request. (Also, include a link to your thread - copy from the address bar)

Many members search our previous posts, and thread titles play a big part of the search. I doubt anybody would do a search based on your title?

To change a Title on your post, click EDIT POST then Go Advanced and change your title, if 2 days have passed ask a moderator to do it for you.