hi, i need help with a computer class excell assignment...im no good at
formulas...
here it is...
In cell E8, use an if function to calculate the employee's base pay.
Base Pay is Pay Rate times the Hours worked but only up to and
including 40 hours. If Hours is greater than 40 do not include any
hours worked over 40 in the base pay amount. Use ONLY cell references
in the function to constant values stored in cells.

Note: base pay is in cell is e8 and hours is in d8.

In cell F8, use an if function to calculate the employee's Overtime Pay
for any hours worked above 40.
...overtime pay is 1.5

thanks so much for any help.


--
brandityler
------------------------------------------------------------------------
brandityler's Profile: http://www.excelforum.com/member.php...o&userid=31418
View this thread: http://www.excelforum.com/showthread...hreadid=514457