I am supposed to calculate the number of regular hours worked based on if the em

Question

I am supposed to calculate the number of regular hours worked based on if the employee is on an hourly or salary pay basis. If a salaried employee, regular hours equal to the hours worked and if an hourly employee, the regular hours equals hours worked up to 40. It was advised to try using the MIN function for this.

=IF(E5="Hourly", MIN(F5 < 41), IF(E5="Salary", F5,"")) This is the equation I have so far, it says the formula is inconsistent.

What I want to say is if E5 is equal to hourly, then the regular hours worked should be up to 40, but if E5 is equal to salary, the regular hours worked is equal to the hours worked.

E5 is the pay basis or the hourly or salary

F5 is the hours worked

G5 is the regular hours which is the column I want the formula in.

I would like to know what is wrong with the formula I have, and how to improve the formula. Thank you in advance.

Explanation / Answer

Hi,

Try this one.

=IF(F5="","",IF(E5="Hourly",MIN(40,F5),IF(E5="Salary",F5,"")))

Related Questions

Navigate

• Browse (All)
• Browse I
• Subjects

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.