Name Dept. Rate Hours Gross Pay
Sally 1 10 20
Joe 2 10 50
Jill 1 20 44
TOTAL 114 $-
I'm taking an online Excel class and the homework assignment asks me to create an =IF formula for the gross pay column shown above. It's due on Sunday night and the instructor does not answer questions over the weekend. I don't understand what the assignment is asking when it states "Create an =IF formula that can be copied". I'm not asking for you to do the formula for me, I just need to understand what it means to create a formula that can be copied? I've read the chapter and I just can't find this info in the chapter. Thanks for your help.
Assignment Question:
. Write an =IF formula for cell E10 that can be copied and will calculate the gross pay based upon the following information: Dept. 1 employees receive straight time for 40 hours or less and double time for hours over 40. Dept. 2 employees receive straight time for 40 hours or less and triple time for hours over 40.
Dan Johnson
Excel 2010
Windows 7
Bookmarks