Needing help with a payroll formula fast

[anthony.fowble]

Attached is a prntscr of my workbook,
Im wanting to start by writing a formula for Patti Stonesifer (the 1st employee in the worksheet)’s gross pay in the Gross Pay column. Regular pay is the employee’s pay for up to 40 hours and is computed as hourly rate * hours worked. Overtime pay is paid for overtime hours. Overtime pay is computed as hourly rate * overtime rate * overtime hours.

• reference Overtime rate in the gross pay formula using absolute cell reference form, i.e. $C$3 so that the formula can be copied. The gross pay is Regular Pay + Overtime Pay. When her gross pay formula is correct, copy it down through the remaining employee’s gross pay cells

but i am having the hardest time coming up with a formula,

can you help? PLEASE!!
hope this makes sense
Anthony


Screenshot ------> http://i1058.photobucket.com/albums/t419/anthonyfowble1/12.jpg[/QUOTE]

 

[anthony.fowble]

hmmm....interesting, let me fiddle with it

 

[anthony.fowble]

i got it to work, i had to manually move to reference cell to the column i wanted, and then drag to copy the formula...go figure..lol

thanks once again