help PLEASE with a formula

B

Bana

I'm sure this is simple, but it's driving me crazy. I have a column of HOURS
WORKED and a column of HOURLY RATES. I need a formula for the GROSS WAGES
column that goes as follows: gross wages are hours worked x rate with time
and a half for hours over 40.
Thanks!
 
W

wally

A simple IF() statement can do this
Let's say that cell A1 holds hours worked and A2 hold rate
of pay

Use a formula something like this
=IF(A1>40,(40*A2)+(A1-40)*(A2*1.5),A1*A2)
Hope this helps
Wally
 
Top