Answered step by step
Verified Expert Solution
Question
1 Approved Answer
You have the following table in Excel. What is the correct formula that should be inserted in the formula bar for Cell C4? Your formula
You have the following table in Excel. What is the correct formula that should be inserted in the formula bar for Cell C4? Your formula should work for C4:C13. Where (take these points as hint for you). Thresholdi 6, Threshold2 =3, Long Hour_Fee = 2 or 2, Med_Hour_Feel - 3 or 3 For example: you can substitute 3 by Med_Hour_Fee in the formula bar expression C20 & B 1 Car Parking Charges F G Car Reg If park >8 hours pay 1 pr hr If park >5 hours pay 1.50 pr hr Anything less "Free Parking" No Hours Parking Parke Charge d 6 18.00 12 24.00 8 16.00 11 22.00 5 15.00 3 Free Parking 12 24.00 7 14.00 Free Parking 6 18.00 DA12 NEI 5 MA16 BVW DD11 SFD 7 MA14 NHG 3 YK14 BHH 9 DY15 FLB 10 MM12 SWL 11 MA16 GKW 12 FS12 DSD U DA11 SBM 6 Threshold1 Threshold 2 Long Hour Fee Med Hour Fee 3 2.00 3.00
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