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 haven't used the SUM function in your formula. The assignment says to check the total of B9:F9, so where should you use SUM?