Forum Discussion
steele86
Sep 13, 2020Copper Contributor
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 ...
SergeiBaklan
Oct 16, 2020MVP
You may use SUM() or whatever function directly without checking the condition by IF(), just add two semicolons in custom format for such cells
Same works with other formats, it shall be nothing after the second semicolon.