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))

 

Resources