Question: In cell H 9 , enter a formula using the IF function to test whether the total hours for the day ( cell c 9
In cell H enter a formula using the IF function to test whether the total hours for the day cell c are greater than the number of regular work hours. If the total hours are greater than display as the number of regular hours in cell H Otherwise, display the total hours cell c
Copy the formula in cell H to the range H:H to calculate the regular hours for each day.
Step by Step Solution
There are 3 Steps involved in it
1 Expert Approved Answer
Step: 1 Unlock
Question Has Been Solved by an Expert!
Get step-by-step solutions from verified subject matter experts
Step: 2 Unlock
Step: 3 Unlock
