Question

In cell e7, create a formula that calculates the salary for sarah, one of the servers at the good breeze hotel. her salary is calculated by multiplying the number of regular hours worked (cell b7) by her hourly rate (cell d7), and then adding to that the number of overtime hours worked (cell c7) multiplied by her hourly rate (cell d7) times 1.5. (hint: sarah is paid 50% more than—or 1.5 times—her regular hourly rate when she works overtime.)

I need the formula

Answer 1

The formula: e7 = (b7*d7)+(c7*d7*1.5)

Explanation:

Given:

Hours worked = b7

Hourly rate = d7

Overtime hours = c7

Salary calculation = e7

Salary = Hours worked*hourly rate + (overtime*hourly rate)*1.5

Formula

e7 = (b7*d7)+(c7*d7*1.5)

The formula e7 = (b7*d7)+(c7*d7*1.5)

Hope this will helpful to you.

Thank you.