I think you need to slightly re-think your design and layout:

Calculate standard hours =MIN(40,Total hours)
Calculate Overtime hours =Max(0,D12-40)
Calculate total hours =std hours+ Ovetime hours

Calculate normal pay =std hours * hourly rate
Calculate Overtime pay =overtime hours * overtime rate #
Calculate gross pay =normal pay+overtime pay

Calculate net (after tax) pay =gross pay*(1-tax rate%)

The cells you gave are different to you Jpeg but it shoud be easy to work
out the above formulae.

# Overtime rate may be different from standard rate

HTH



"PaxtonPoe" wrote:


the above automatically includes 40hrs but some weeks I may not work 40
hours



I HAVE ATTACHED AN UPDATE OF THE WORKSHEET AND HAVE THE BACKGROUNDS OF
THE FORMULAS I NEED HIGHLIGHTED IN TURQUOISE

the cells I need:
OT Hrs (D13) - I want D13 to display how many overtime hours IF there
are more than 40 in Total Hours D12

OT Pay (D14) - Overtime pay I want to be calculated (Overtime Hours,
D13 * Current Pay/hr:, A9 * Taxes Excluded, A12)

Total Pay (D16) - (Total Hrs 40 or under *Current Pay/hr:, A9 * Taxes
Excluded, A12) + OT Pay, D14

Thanks again


+-------------------------------------------------------------------+
|Filename: excel.JPG |
|Download: http://www.excelforum.com/attachment.php?postid=4960 |
+-------------------------------------------------------------------+

--
PaxtonPoe
------------------------------------------------------------------------
PaxtonPoe's Profile: http://www.excelforum.com/member.php...o&userid=35913
View this thread: http://www.excelforum.com/showthread...hreadid=557068