Question
A movie theater has a normal ticket price of $12. For shows that start between 7 pm and 1 am, there no discount. For shows
A movie theater has a normal ticket price of $12. For shows that start between 7 pm and 1 am, there no discount. For shows that start at other times, there are special prices for the following age ranges: individuals whose under 12 pay only $8; individuals, whose age is between 12 and 16 inclusive, pay only $10; individuals whose age is 65 or over pay $9.50. VBA function that gets the individual's age from the worksheet and retums the ticket i cost. Your function can get the current time of day in hours (on a 24 hour clock) by a statement like timeHr For example f the time was between 7 pm and 7:59:59 pm, the statement tmeHrs Hour(Now) would return a valua of You must Use an if -elseif- else -endif structure. Call m o Problem 3
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started