A student figuring a formula for wages

[younglifer]

Hello, I am beginner student trying to figure out a formula that
calculates how to pay people for the number of hours they work, and at
the same time figure out any overtime they may have.

The wage is in cell B4, and the # of hours is in cell C4. Overtime is
figured at 1.5 of the wage in B4. I must put the end result in F4.

The instructor rushed through his presentation, and said to use the "if
function". The assignment is due on tuesday and any help with this is
greatly appreciated.
-Thanks in advance

 

[Gord Dibben]

An excellent tutorial and workbook download on this subject can be found at
Chip Pearson's site.

http://www.cpearson.com/excel/overtime.htm

Gord Dibben XL2002

 

[Bill Sharpe]

Younglifer needs a formula in F4 that uses the IF function. He should look
up the IF function in Excel's help to see the three arguments this function
takes. The condition to check is whether the hours exceed 40. If so,he will
need to do some math to calculate the total wage including overtime. If the
hours are less than 40, then the wage is just the number of hours worked
times the hourly rate -- that's easy. If the hours are greater than 40 then
the total wage is 40 hours times the hourly rate plus 1.5 times the rate
times the number of hours over 40.

I don't want to just tell the student what the exact formula looks like; he
should be able to figure it out logically.

Bill

An excellent tutorial and workbook download on this subject can be found at
Chip Pearson's site.

http://www.cpearson.com/excel/overtime.htm

Gord Dibben XL2002

 

[Guest]

-----Original Message-----

Hello, I am beginner student trying to figure out a formula that
calculates how to pay people for the number of hours they work, and at
the same time figure out any overtime they may have.

The wage is in cell B4, and the # of hours is in cell C4. Overtime is
figured at 1.5 of the wage in B4. I must put the end result in F4.

The instructor rushed through his presentation, and said to use the "if
function". The assignment is due on tuesday and any help with this is
greatly appreciated.
-Thanks in advance


------------------------------------------------
[/url]
~~View and post usenet messages directly from http://www.ExcelForum.com/

.
if the number of hours are over 40 then add ot to wage