Excel Nested Formula help

I cannot get this formula, been at it for hours. any help would be appreciated.

 EXCEL-4. 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.

Answer
Answer

Dear Cunard,

Good day! Thank you for posting to Microsoft Community. We are happy to help you.

 

As per your description, you may try this formula: =IF(SUM(B9:F9)=0,"",SUM(B9:F9))

 

 

Image

If this is not your requirement, could you please upload a screenshot of your data sheet view for our reference so we can understand your exact scenario and provide our suggestion in a productive manner, perhaps some related screenshots will be helpful.

Your understanding and patience will be highly appreciated. I hope that you are keeping safe and well!

Sincerely, 

Waqas Muhammad

• Beware of Scammers posting fake Support Numbers here.

20 people found this reply helpful

·

Was this reply helpful?

Sorry this didn't help.

Great! Thanks for your feedback.

How satisfied are you with this reply?

Thanks for your feedback, it helps us improve the site.

How satisfied are you with this reply?

Thanks for your feedback.

 
 

Question Info


Last updated March 30, 2025 Views 4,487 Applies to: