N/A Column leads to #DIVIDE BY ZERO
I'm working on an onboarding tracker where I'm using an "N/A" checkbox in order not to count the modules that individuals aren't required to take. I'm using another checkbox to represent "Done" and the percentage complete  =COUNTIF(CHILDREN(Done16), 1) / COUNTIF(CHILDREN([N/A]16), 0)
If an entire module is chosen as "N/A" the result is #DIVIDE BY ZERO. Is there a way to alter the formula to not divide by a number?
Comments

=COUNTIF(CHILDREN(Done16), 1) / if(COUNTIF(CHILDREN([N/A]16), 0) = 0,1,COUNTIF(CHILDREN([N/A]16), 0))
You cannot divide by zero. If there aren't any checked N/A, then your denominator is zero and you have an incorrect formula. You just need to check the case that the denominator is 0 and post a 1 instead.
Help Article Resources
Categories
 All Categories
 14 Welcome to the Community
 Smartsheet Customer Resources
 62.1K Get Help
 349 Global Discussions
 198 Industry Talk
 427 Announcements
 4.4K Ideas & Feature Requests
 133 Brandfolder
 127 Just for fun
 127 Community Job Board
 455 Show & Tell
 28 Member Spotlight
 1 SmartStories
 283 Events
 36 Webinars
 7.3K Forum Archives
Check out the Formula Handbook template!