Forum Discussion

steele86's avatar
steele86
Copper Contributor
Sep 13, 2020

If and Sum Nested formula

This is what I have =if(b9:F9=0,"",B9:F9). Obviously it's not working lol. I'm having trouble with the false. According to my assignment, it's supposed to display the sum if it is false.   here is ...
Excel
Riny_van_Eekelen's avatar
Riny_van_Eekelen
Platinum Contributor
Oct 16, 2020

Oldrockz Try this:

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

 

JBailey992's avatar
JBailey992
Copper Contributor
Mar 19, 2022
Thank you! I also am working on this assignment for Excel and could not figure out this formula either. I greatly appreciate your help!

Resources