Answered step by step
Verified Expert Solution
Question
1 Approved Answer
B D 1 Pesko Store Car Parking Charges 2 Hours Parking 3 Car Reg Parked Charge 4 DA12 NEJ 0.5 5 MA16 BVW 4.0 6
B D 1 Pesko Store Car Parking Charges 2 Hours Parking 3 Car Reg Parked Charge 4 DA12 NEJ 0.5 5 MA16 BVW 4.0 6 0011 SFD 1.5 MAI NH 2.0 8 YK14 BHH 5.5 9 DY15 FLB 3.0 10 MM12 SW 0.5 31 12 If park c 2 hrs, no fee (message) 13 Anything more pay 2 per hour 14 15 Threshold 16 Parking fee 2.00 We want to use an =IF function to calculate the parking charge. In cell C4, create an =IF function to calculate the parking charge. Use the following to help you: . If the hours parked are less than or equal to 2 hrs, display a message saying Free parking If the hours are greater, the parking fee is Hours Parked Parking Charge
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