Percentage formula does not work if denominator is zero

Hi, I have the formula for percentage but when denominator is zero, instead of showing 0%, it does not show anything. How can I make it such that it returns zero if that is appropriate so that my run chart does not look like its missing data points? Thank you!


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!