IF Error Function help

Hello, Request your help to figure out what I may be doing wrong here. Please see the screen shot below

The formula is on the % complete column below. I want the #DIVIDE BY ZERO to be a NULL value and was trying to use the formula below .

The formula gets the desired result but I want the I want the #DIVIDE BY ZERO to be a NULL

=IFERROR([Count Checked]@row / Total@row * 100 + "%"), " ")

Find more posts tagged with

Formulas

Accepted answers

Corey W.

You just have a missing parenthesis. Try:

=IFERROR(([Count Checked]@row / Total@row * 100 + "%"), " ")

All comments

Corey W.

You just have a missing parenthesis. Try:

=IFERROR(([Count Checked]@row / Total@row * 100 + "%"), " ")

roya

Thank you so much!!! Corey!!!

This worked!!! I really appreciate your help.

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.