Question: 1 . In cell I 9 , enter a formula using the IF function to test whether the total hours for the day ( cell

1. In cell I9, enter a formula using the IF function to test whether the total hours for the day (cell G9) are greater than 8. If they are, subtract 8 from the total hours (cell G9) to display the number of overtime hours in cell I9. Otherwise, display 0.
Copy the formula in cell I9 to the range I10:I15 to calculate the overtime hours for each day.

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Programming Questions!

Q:

Cello Worldwide Current date: Customer ID Location Customer Since CS-104 N 2016/03/12 CS-212 SW 2015/02/16 CS-606 SE 2017/12/15 CS-418 N 2020/04/17 CS-192 SW 2020/11/06 CS-202 SW 2019/04/15 CS-301 SE...

Q:

d . In cell G 2 , enter a formula using the IF function to determine whether the daily sales goal in cell K 2 was met. Display yes if the value in the Daily Total ( $ ) column is greater than or...

Q:

type Q1 Q2 Q3 Q4 Total mini 2,290 2,297 2,298 2,289 9,174 voice activated 1,509 1,509 1,514 1,511 6,043 water proof 1,517 1,520 1,524 1,528 6,089 total 5,316 5,326 5,336 5,328 21,309 This is the...

Q:

3. Benicio started to define names for cells and ranges in the All Locations worksheet to make it easy to identify the total sales for each product. He wants you to add a defined name for the...

Q:

((EXCEL)) I am having a hard time figuring out the correct formula to this question. If anyone could help out, I'd really appreciate it! Brett assigns each client a rating of A, B, or C depending on...

Q:

Twenty Four Frames plans to find out whether the more hours viewed, is due to the user's data package and Twenty Four Frames premium plan. Determine whether these packages are related to the number...

Q:

In the range B 1 2 :E 1 2 , Benicio wants to display a rating depending on the total sales for each quarter. He the rating criteria in the range A 1 4 :F 1 5 . For example, if total sales in Quarter...

Q:

Brett assigns each client a rating of A , B , or C depending on the number of days an Involce Is overdue. Display this information using a nested IF function as follows:a . In cell 1 6 , insert a...

Q:

Next, Margarita asks you to complete the Bonuses Earned data in the range C12:H15. The amount eligible for a bonus depends on the quarterly revenue. The providers and staff reimburse the clinic $1250...

Q:

b. In cell C13, enter a formula using an IF function that tests whether cell C9 is greater than 230,000. If it is, multiply cell C9 by 0.20 to calculate the 20 percent eligible amount. If cell C9 is...

Q:

An economy is described by the following equations: C = 2,600 + 0.8(Y - T) - 10,000r V = 2,000 - 10,000r G = 1,800 NX = 0 T = 3,000 The real interest rate, expressed as a decimal, is 0.10 (that is,...

Q:

Calculate Indirect Taxes from the following data: Particulars Rs. in crores 55,915 (i) NDP at FC (ii) Subsidies 1,540 (iii) Factor income from abroad 635 (iv) Consumption of Fixed Capital1,625 (v)...

Q:

Question 6 1 pts An annuity is best described as which of the following statements? A stream of equal cash installments made at equal time intervals Another term used for future valur Another term...

Q:

Which of the following aspects of the market and transportation revolutions impacted the Civil War? telegraph railroad steamboats all of the above