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: pay is in cell is c8 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.
Bookmarks