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 & 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

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

Making Accountability Work Dilemmas For Evaluation And For Audit

Authors: Marie-Louise Bemelmans-Videc, Jeremy Lonsdale, Burt Perrin

1st Edition

1412865557, 978-1412865555

More Books

Students also viewed these Accounting questions

Question

Briefly explain the principle behind CDMA.

Answered: 1 week ago