Detecting Sum formula "null" value
Hi Community
I have a simple sheet with a mixture of parent and child rows. Not all parent rows have child rows. I have a very simple formula [=SUM(CHILDREN())] to sum the value of child rows for a parent row where they exist. Where there are no child rows the formula returns a "0". I use conditional formatting to change the colour of a cell based on the value from the SUM formula. This works fine for any value returned other than the null value where there are no child rows. I want to change the text colour to the background of these "null" value cells so they appear blank rather than showing "0", but can't work out what the "0" returned actually is. I have tried all the variations in the conditional formatting options with no luck. Any one know what "value" is returned by my formula when there are no child rows?
Answers
-
Are you able to provide screenshots for context?
-
Thanks for the follow up Paul - a weekend away of staring at it and the solution became obvious - fixed it first thing this morning in about 30 seconds 😂.
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 64.8K Get Help
- 434 Global Discussions
- 138 Industry Talk
- 470 Announcements
- 4.9K Ideas & Feature Requests
- 129 Brandfolder
- 148 Just for fun
- 65 Community Job Board
- 486 Show & Tell
- 33 Member Spotlight
- 2 SmartStories
- 300 Events
- 36 Webinars
- 7.3K Forum Archives