View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Don Guillett
 
Posts: n/a
Default formula help please

And who, pray tell, will you tell the teacher to give the grade to?
We only do homework around here when we can't tell that it's homework.<G

--
Don Guillett
SalesAid Software

"brandityler"
wrote in message
...

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