Question: Please help me with what I'm doing wrong. I keep getting negative numbers using this formula. Thanks! 2 . E F G J K L

 Please help me with what I'm doing wrong. I keep gettingnegative numbers using this formula. Thanks! 2 . E F G J

Please help me with what I'm doing wrong. I keep getting negative numbers using this formula. Thanks!

2 . E F G J K L M N H Timesheet due 3/5/2021 1 B D Reporting Period Hours Name Period start 2/1/2021 Period end 2/26/2021 Date completed 9/10/2020 2 3 4 Summary Week # 5 Balances 1 Period Start Period End 28.00 6 7 Hours Worked 0.001 Worked Holiday Vacation Sick 8 Week # Mon Tue Wed Thu Fri 0.001 56.00 -56.00 9 1 8 8.5 7.5 4 0 10.00 24.00 - 14.00 -4.500 10 2 8 7.5 9 7.5 8 2.001 6.50 Comp Total 11 3 0 8 8.5 8.5 7 40.000 86.50 -74.50 12 4 9 8.5 9.5 9 13 14 15 Hours Used Other Hours Used Hours worked per day Week # Hours Worked Total Hours For Week 16 Holiday Vacation Sick Average Comp 7.2 1 17 28.00 Maximum 10.00 2.00 40.00 9.5 2 Minimum 18 40.00 40.00 0 3 19 32.00 8.00 40.00 4 44.00 44.00 20 21 22 23 8. Add formulas to complete the balances section. In cell K8, create a formula using the SUM function that calculates the total of the range D17:020 and subtracts it from the value in cell 18. 9. In cell K9, create a formula using the SUM function that calculates the total of the range E17:E20 and subtracts it from the value in cell 19. 10. In cell K10, create a formula using the SUM function that calculates the total of the range F17:F20, subtracts it from the value in cell J10, adds the total of the range G17:G20, and subtracts 160

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Accounting Questions!