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
 10.9K Get Help
 65 Global Discussions
 69 Industry Talk
 385 Announcements
 3.6K Ideas & Feature Requests
 56 Brandfolder
 125 Just for fun
 50 Community Job Board
 464 Show & Tell
 40 Member Spotlight
 44 Power Your Process
 28 Sponsor X
 234 Events
 7.3K Forum Archives
Check out the Formula Handbook template!