davidhall80
Well-known Member
- Joined
- Jul 8, 2006
- Messages
- 663
Same as before but with addition
Column A Has Zone 1 through Zone 9. Column B has "New", "Change", or "Old". Column C has Pay Rate. Column D has REG hours worked. Column E has OT Hours worked. OT and REG pay is the same, so I would like to get total Gross Pay for "Zone 2" "New" assignments. If column A = Zone 2, and Column B = New, than multiply C with the sum of D and E add all those products together. The difference here is D and E have to be added together before multiplying to C..............
Column A Has Zone 1 through Zone 9. Column B has "New", "Change", or "Old". Column C has Pay Rate. Column D has REG hours worked. Column E has OT Hours worked. OT and REG pay is the same, so I would like to get total Gross Pay for "Zone 2" "New" assignments. If column A = Zone 2, and Column B = New, than multiply C with the sum of D and E add all those products together. The difference here is D and E have to be added together before multiplying to C..............