Hi there, im new here but i was wondering if I could get some help please?
Im constructing a spreadsheet that will be used by a restaurant for bookings, adding items to bills etc. I have all the table capacities grouped together in blocks, e.g. and the tables that can take 2 people, 4, 6, 10 etc. Ive made a form that allows the user to select a time for booking e.g 7:45 and the active cell become the first table of 2 under that time. I then have a message box that promts the user to enter in the number of people that are in the group and then the name of the group, this information will then hopefully be input into the spreadsheet in the appropriate areas. How can i use an IF statement to say if the number entered is 2 or less go to cell, if its 3 or 4 go to cell etc? The other problem with this is that it needs to be able to recognise if there is already a booking, say i have four tables of two, and one is already booked, how do i make it go to the next available slot?
If anyone can throw me some info on the subject then i'd really appreciate it. Thanks, Scuzz
Im constructing a spreadsheet that will be used by a restaurant for bookings, adding items to bills etc. I have all the table capacities grouped together in blocks, e.g. and the tables that can take 2 people, 4, 6, 10 etc. Ive made a form that allows the user to select a time for booking e.g 7:45 and the active cell become the first table of 2 under that time. I then have a message box that promts the user to enter in the number of people that are in the group and then the name of the group, this information will then hopefully be input into the spreadsheet in the appropriate areas. How can i use an IF statement to say if the number entered is 2 or less go to cell, if its 3 or 4 go to cell etc? The other problem with this is that it needs to be able to recognise if there is already a booking, say i have four tables of two, and one is already booked, how do i make it go to the next available slot?
If anyone can throw me some info on the subject then i'd really appreciate it. Thanks, Scuzz