Answers
2
LOL! I used the same formula, and I was so confused when I got a red checkmark. Later, one of my friends taught me that the correct formula is =IF(SUM(B9:F9)=0,"",SUM(B9:F9))
The full question is: 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 nothing (indicated with two quote marks: ""). Otherwise, 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.
I did =IF(COUNT(B9:F9)=0,"",SUM(B9:F9)), and the answer is correct, but the report is saying it is not correct. pls hlp
LOL! I used the same formula, and I was so confused when I got a red checkmark. Later, one of my friends taught me that the correct formula is =IF(SUM(B9:F9)=0,"",SUM(B9:F9))
Reading books is a great way to learn. Here are some of the books we recommend.
You entered an incorrect formula. You are supposed to check the total number of hours in week 1, so u need to use SUM function instead of COUNT function.
The correct formula to be entered in B17 is =IF(SUM(B9:F9)=0,"",SUM(B9:F9)).
When you move your cursor to the corner of B17, it will change to a + sign. After that, drag it up to B20, and the cells will be automatically filled with the correct formula.