Forum Discussion
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 ...
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.