formula help - payroll

B

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
 
N

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How do I combine the 4 IF formulas into 1 formula 5
Count non-consecutive cells..... 7
excell - payroll carry over 3
time format multiplied by hours worked ? 2
calculateing MIN,MAX cells for purpose of payroll 3
have value in A1 & want value after 20 cells is it =a1+20 ???? 1
Hours worked computation??? 2
Need a worksheet function that will search through a row of common entries and return the one that i 6

Top