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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Work Budget Salary vs Real Time Salary 0
What Excel formula converts hourly wage to annual salary 5
Trying to create a report that will list unmatched records by Ticket Primary Key 0
Copy addition formula of non-consecutive horizontal cells 2
Calculating Numbers 0
How do I write a IF function formula? 4
Two columns followed by single page-width column on same page 0
Calculations using time and currency 2

Top