Working out wagees

S

Sean

ok heres my problem

i have a sheet working out my wages (only an est.) but it does most of the
math for me ie tax payment, total with over time without deductions etc BUT i
want the over time cell to work out my overtime rate ONLY if the total hour
sheet and the total hour cell minues lunch break cell read 40+ is this
possable or am i asking to much off the spred sheet? (this saves data input
in the long run)
 
S

Sean

Sean said:
ok heres my problem

i have a sheet working out my wages (only an est.) but it does most of the
math for me ie tax payment, total with over time without deductions etc BUT i
want the over time cell to work out my overtime rate ONLY if the total hour
sheet and the total hour cell minues lunch break cell read 40+ is this
possable or am i asking to much off the spred sheet? (this saves data input
in the long run)
Click to expand...


oh here are my formulas

=SUM(D16:D20) <<total hours
=SUM(E16:E20) << total hours after lunch break removed
=SUM(B23-40) << Overtime hours worked out from formula above
=SUM(B25*10.5) << overtime pay from hours worked out by overtime hour formula

as you can tell im very limited with exel
 
D

daddylonglegs

I'm assuming you have hours in decimal format not time format.....

If you change your 3rd formula to

=MAX(B23-40,0)

then when B23 is less than 40 the result of this formula will be zero
so the next formula...

=SUM(B25*10.5)

will also return a zero.

In that last formula you don't need the SUM function, this will
suffice

=B25*10.5
 
B

Bob Phillips

Change

=SUM(B23-40)

to

=MAX(B23-40,0)

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)
 
Top