Answered step by step
Verified Expert Solution
Link Copied!

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

image text in transcribed

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 f B D 1 Car Parking Charges G Car Reg If park >8 hours pay 1 pr hr If park >5 hours pay 1.50 pr hr Anything less "Free Parking" 12 4 DA12 NE) 5 MA16 BVW DD11 SFD 7 MA14 NHG 8 YK14 BHH 9 DY15 FLB 10 MM12 SWL 11 MA16 GKW 12 FS12 DSD 13 DA11 SBM No Hours Parking Parke Charge d 6 18.00 24.00 8 16.00 11 22.00 5 15.00 3 Free Parking 12 24.00 7 14.00 1 Free Parking 6 18.00 Threshold1 Threshold 2 Long Hour Fee Med Hour Fee 6 3 2.00 3.00

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Datacasting How To Stream Databases Over The Internet

Authors: Jessica Keyes

1st Edition

007034678X, 978-0070346789

More Books

Students also viewed these Databases questions