Question

add formulas to complete the table of hours used. in cell B17, create a nested formula...

add formulas to complete the table of hours used. in cell B17, create a nested formula with the IF and SUM functions that check if the total number of hours worked in week 1 (cells B9:F9) is equal to 0. if it is, the cell should display the total number of hours worked in week 1. copy the formula from cell B17 to fill the range B18:B20

Engineering   Computer-Science   
0 0
Add a commentTranscribed image text
Next >

Homework Answers

Answer #1

=IF(SUM(B9:F9) = 0, SUM(B9:F9), "")

I suspect that there is something missing in the question.. It says if week1 total hours are 0, then display week1's total hours.. which means, the result will be 0 only.. It also do not tell what should be the value, when total hours are not 0.

please clarify the question further in comments if you are not satisfied with the answer.. HOwever, I have showed how you can write the answer, so it certainly will help you in amend the answer as per your need.

0 0
Know the answer?
Your Answer:

Post as a guest

Your Name:

What's your source?

Earn Coins

Coins can be redeemed for fabulous gifts.

Log In

Sign Up

Not the answer you're looking for?
Ask your own homework help question
Similar Questions
For this problem, you must create a table of values for x in [−1, 1] with...
For this problem, you must create a table of values for x in [−1, 1] with a separation of h = 0.02 for the function f(x) = x5 − 0.36x3 + .2563. Then create the table for the approximate f′(x), as in the example problem. Make sure to format the cells as Number so values appear correctly. For the cells in columns B and C, use decimal numbers with 6 places. Once the table is created, make the scatterplot that...
Part 3 – Steelcase Production Steelcase Corporation manufactures 3 basic products: chairs, desks, and tables. Below...
Part 3 – Steelcase Production Steelcase Corporation manufactures 3 basic products: chairs, desks, and tables. Below is chart which summarizes the number of labor hours spent for each product in each division. Chairs Desks Tables Process Carpentry 2 3 6 Finishing 1 1 1 Assembly 4 6 2 In a given week, Steelcase has 250 hours available for carpentry, 100 hours available for finishing, and 400 hours available for assembly. Steelcase makes a profit of $66 on each chair, $75...
Applications I Consider the following data representing the total time (in hours) a student spent on...
Applications I Consider the following data representing the total time (in hours) a student spent on reviewing for the Stat final exam and the actual score on the final. The sample of 10 students was taken from a class and the following answers were reported. time score 0 23 4 30 5 32 7 50 8 45 10 55 12 60 15 70 18 80 20 100 Part 1: Use the formulas provided on the 3rd formula sheet to compute...
Statistical Analysis for Business Applications I Consider the following data representing the total time (in hours)...
Statistical Analysis for Business Applications I Consider the following data representing the total time (in hours) a student spent on reviewing for the Stat final exam and the actual score on the final. The sample of 10 students was taken from a class and the following answers were reported. time score 0 23 4 30 5 32 7 50 8 45 10 55 12 60 15 70 18 80 20 100 Part 1: Use the formulas provided on the 3rd...
Practice using EXCEL – Part of your Orientation Assignment to prepare for class on the first...
Practice using EXCEL – Part of your Orientation Assignment to prepare for class on the first day. Step by Step instructions on completing PR1-5B. BEFORE STARTING TO WORK THE PROBLEM YOU NEED TO WRITE ALL BALANCE FORMULAS. To do so do the following in order. Click on Cell D39. In D39 you will write a formula to add rows D37 and D38. To do so do the following: a)    Start in Cell D39 and press = sign b)    Highlight cell...
In this assignment you will analyze the performance of actual company divisions. FASB ASC 280 (formerly...
In this assignment you will analyze the performance of actual company divisions. FASB ASC 280 (formerly SFAS 131) requires publicly traded companies to disclose segment information in the notes to the financial statements. You will use Excel to create visually appealing data tables and bar charts to analyze division performance, and then comment on the results.    Due Date: Tuesday, May 1, 2018.   Submit as an attachment in Blackboard in the Module 24 Assignment. SECTION I The link is to...
Arrays, loops, functions: Lotto Element Repeated Function Write a function that that takes as parameters an...
Arrays, loops, functions: Lotto Element Repeated Function Write a function that that takes as parameters an array of ints, an int value named element, and an int value named end. Return a bool based on whether the element appears in the array starting from index 0 and up to but not including the end index. Generate Random Array Write a function that takes as parameters an array of integers and another integer for the size of the array. Create a...
Create a C++ project. Download and add the attached .h and .cpp to the project. Write...
Create a C++ project. Download and add the attached .h and .cpp to the project. Write an implementation file to implement the namespace declared in the attached CSCI361Proj5.h. Name the implementation file as YourNameProj5.cpp and add it to the project. Run the project to see your grade. .h file: // Provided by: ____________(your name here)__________ // Email Address: ____________(your email address here)________ // FILE: link.h // PROVIDES: A toolkit of 14 functions for manipulating linked lists. Each // node of...
Use Python to Complete the following on a single text file and submit your code and...
Use Python to Complete the following on a single text file and submit your code and your output as separate documents. For each problem create the necessary list objects and write code to perform the following examples: Sum all the items in a list. Multiply all the items in a list. Get the largest number from a list. Get the smallest number from a list. Remove duplicates from a list. Check a list is empty or not. Clone or copy...
Cajun Jack needs $45,000 for a boat used to hunt crocodiles that are used both for...
Cajun Jack needs $45,000 for a boat used to hunt crocodiles that are used both for their leather and meat. Cajun is considering taking a 9-year loan for the required amount and he talked to the lenders from his local Bank and Credit Union regarding loan options. The local bank charges 6.25% per year compounding quarterly and requires quarterly repayments. (a) Calculate the quarterly repayment for both principal and interest that Cajun would have to make on this loan. If...
ADVERTISEMENT
Need Online Homework Help?

Get Answers For Free
Most questions answered within 1 hours.

Ask a Question
ADVERTISEMENT