would like to add an IFERROR to a simple formula, can't seem to get it to work

Hi,

I have a simple formula I am using in one of my sheets to calculate a percentage:

=[Training/90 day complete]@row / FDS@row

I would like to amend it so that if the cell in the Training/90day complete column is blank, to leave it blank rather than calculating it and returning 0%.

How would I do that?

Thanks in advance!

Emily

Find more posts tagged with

Formulas

Accepted answers

All comments

Dale Murphy

@Emily Sanchez Here is what I would use:

=IFERROR(IF(ISBLANK([Training/90day complete]@row), "", ([Training/90day complete]@row / FDS@row)), "")

ISBLANK should catch the condition where Training/90day is blank

IFERROR should catch the condition where FDS is blank.

(seems to work in North America)

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.