I’m looking for help and advice.im creating a new booking form for a Families Club that I want to self generate a price using drop down menus. So your first option will be a start finish time the difference will give me the hours required for. Then if they want they want bar hire if a no it’s a simple time x 10 an hour however if they require cleaner drop down is yes then add £20 and if they want soft play drop down yes add £20 a further £50 will be added as a deposit. If they click yes to bar then the rate will go up dependant on number of guest which is in a drop menu 0-100 100-150 etc and price goes up so starts at£25 hr then £35 hr. then same as before if they click yes to cleaner add £20 yes to soft play add £50 yes to dj add £25 and the deopisit will need to be £100 I want th systemto generate the price from there option how do I do this? I’ve added picture of current form in word but I want to create this in excel so it’s just option and generates a price so that it will self generate an invoice from the quote.
Bookmarks