How to hide #DIVIDE BY ZERO error message



I am looking for help utilizing a formula to hide the #DIVIDE BY ZERO error message.

My current formula in the "Change" column is simple:

=([Availability %]@row - [Previous Availability %]@row) / [Previous Availability %]@row

But for any cells in the "Previous Availability %" column that have 0%, I get the #DIVIDE BY ZERO error and I'd like that to be hidden.

Thank you,



Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!