Question

11-7. At the Downtown Theater: Orchestra seats are $60, Mezzanine seats are $40, and Balcony seats are $20. Children (under 12) are half price. Seniors (65 or over) receive a $5 discount. Create a worksheet that allows you to enter the location of the ticket desired and the age of the person and gives you the price of the ticket. If the person types in an illegal seat location the worksheet should so inform the user. You can use as many cells as you would like. Try your worksheet for Orchestra for an 88-year-old, Mezzanine for a 7 year-old, Backstage for an 18 year-old, and Orchestra for a 21 year-old.

Answer 1

I can't upload worksheet here, so i give u some instructions which help u to make desired workbook by your own:

In brackets there are cell references like Column C and Row 6 is C6.

Instructions

Write following in there place as instructed :

Type of Seat in (C6) and Orchestra in (D6)

Age in (C7) and 88 in (D7)

Ticket Price in (C8) and in D8 paste below mentioned formula

=IFERROR(VLOOKUP(IF(OR(D6="Orchestra",D6="Mezzanine",D6="Balcony"),D6,"Seat")&"#"&IF(D7="","Age",IF(D7<=12,"A<=12",IF(D7>=65,"A=>65","12>A<65"))),$J$6:$K$15,2,0),IF(OR(D6="Orchestra",D6="Mezzanine",D6="Balcony"),IF(D7="","Please fill the age",0),"Type of seat is not correct"))

And now i give you a table which you need to put in manner so that it's cover H6 to H15 vertically and H6 to K6 horizontally.

Table is as follows

Seat Age Uniquekey Price

Orchestra A<=12 Orchestra#A<=12 30

Mezzanine A<=12 Mezzanine#A<=12 20

Balcony A<=12 Balcony#A<=12 10

Orchestra A=>65 Orchestra#A=>65 55

Mezzanine A=>65 Mezzanine#A=>65 35

Balcony A=>65 Balcony#A=>65 15

Orchestra 12>A<65 Orchestra#12>A<65 60

Mezzanine 12>A<65 Mezzanine#12>A<65 40

Balcony 12>A<65 Balcony#12>A<65 20