formula help - payroll

[Bill S]

I have been scouring these posts and although I think I
need to use "IF" I am not certain. I am not an expert
excel user. I want to compare a cell (that will be a sum
of 7 cells containing hrs worked) to 40. If the number is
equal to or less than 40, multiply by "m1"(regular hourly
rate). If the number is greater than 40, multiply 40
by "m1" , then subtract 40 from the number and multiply
that amount by "n1"(overtime rate). Can this be done??
Thanks for any help.
A1 - daily hours
B1 - daily hours
c1 - daily hours
D1 - daily hours
E1 - daily hours
F1 - daily hours
G1 - daily hours
H1 - sum(A1:G1)
I1 - sum(IF H1<40,H1*M1,(40*M1)+(H1-40)*N1
M1 - regular hourly rate
N1 - overtime hourly rate

 

[Norman Harker]

Hi Bill!

Try:

=IF(H1<=40,H1*M1,(40*M1)+((H1-40)*N1))

--
Regards
Norman Harker MVP (Excel)
Sydney, Australia
(e-mail address removed)
Excel and Word Function Lists (Classifications, Syntax and Arguments)
available free to good homes.