#Divide by Zero Error

HI! Can someone help me rewrite my formula below to get rid of the #divide by zero error in my sheet? I want it to show a zero. If we have a zero in the formula it would be in the comps column. I'm having issues wrapping my brain around how it needs to look


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!