Answered step by step
Verified Expert Solution
Question
1 Approved Answer
How do I put this as a function for excel? 1. Go to cell H5 to calculate the Regular Hours. This will use an IF
How do I put this as a function for excel?
1. Go to cell H5 to calculate the Regular Hours. This will use an IF function.
a. If total hours are greater than 40 then Regular Hours are 40
b. Else Regular Hours is the contents of cell G5
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