Sorry I wasnt specific

[Sami66]

Please help a rookie!
I am only asking for help after Ive wracked my brain trying to figur
this one out.

I am doing a payroll spreadsheet with columns of "hours worked" an
"hourly payrate". I am now trying to do the formula for another column
"Gross Pay" How in the world do I take overtime in account in thi
column ALONG with 40 or less hours????

Column D=Hours worked
Column E=Payrate
Column F=gross pay (whether or not overtime was used)

Im trying to use the "if" function to do a formula in column F, but
cant. I got the non overtime totals, but if overtime was used, the wor
"false" fills the particular cell.

Please help! Thank you in advance!

I am attaching the actual spreadsheet Im trying to do if you want t
see it. Thanks again!

Sa

Attachment filename: project 3.xls
Download attachment: http://www.excelforum.com/attachment.php?postid=61142

 

[tjtjjtjt]

This is a little crude, but it gets the job done assuming overtime is worth 1.5 times the normal hourly rate and overtime kicks in after 40 hours.

=IF(D6<=40,D6*E6,(40*E6)+((D6-40)*(E6*1.5)))

tj