How to hide #DIVIDE BY ZERO error message

Hello,

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,

Stephanie

Find more posts tagged with

Formulas

Solution Center

Project Management

Accepted answers

All comments

Marlana K.

Hi @Stephanie_A_W Use IFERROR and , " " for the value if false this will leave it blank.

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

see the difference in mine when using If error

Stephanie_A_W

Hi Marlana,

This worked. Thank you!!

Marlana K.

Hi Stephanie!

Happy to have helped.

Sign in to join the conversation!

Quick Links

Component react.discussion.discussions had an error.

ref must be one of: categoryID, siteSectionID, category, category/categoryID, category/name, category/description, category/url, category/allowedDiscussionTypes, locale, siteSection, siteSection/basePath, siteSection/contentLocale, siteSection/sectionGroup, siteSection/sectionID, siteSection/name, siteSection/description, siteSection/apps, siteSection/attributes, layoutViewType, discussionID, commentID, page, sort, discussion, discussion/name, tags, breadcrumbs, discussionApiParams, serverDraftID, serverDraft.