Hi!

Try this:

=IF(S580,(S5-80)*A1*1.5+80*A1,S5*A1)

Biff

-----Original Message-----
Duane,
I inserted this formula T5 cell.
Made A1 = 8
So I inserted 6 into B5 all the way to P5.
The formula is giving me a different figure than I
should have.
Myrna


"duane" wrote:


something like

assuming a1 = hourly rate=8/hr

t5=sum(b5:h5)*a1+if(sum(b5:h5)40,sum(b5:h5)-40,0)
*a1*1.5+
sum(i5:o5)*a1+if(sum(i5:o5)40,sum(i5:o5)-40,0)*a1*1.5+
p5*a1

B5 to H5 is 1 week, I5 to O5 is 2nd week, P5 is a
single day. S5 =
total
hours. T5 is Gross Pay = total hours x 8 an hr


--
duane


--------------------------------------------------------
----------------
duane's Profile: http://www.excelforum.com/member.php?
action=getinfo&userid=11624
View this thread:
http://www.excelforum.com/showthread...hreadid=276115


.