At the Downtown Theater: Orchestra seats are $40, Mezzanine seats are $30, and Balcony seats are $20. Children (under 12) are half price. Seniors (65 or over) receive a $5 discount. Complete the model on the Problem 1 worksheet, so that if you enter a ticket location in cell C14 and an age in cell C15, you get the final price of the ticket in cell C18. If the person types in a non-valid seat location in cell C14, your formula should return the text "Invalid Location" rather than an error. Note. If easier for you, you can first find the ticket price BEFORE discount (enter that formula in cell C19) and then use it in cell C18 to find the final, after discount, price. Test your formula for Orchestra for an 88-years-old, Mezzanine for a 7 years-old, Backstage for an 18 year-old, and Orchestra for a 21 year-old.
