Combining If Error formula with my existing formula.

I currently have a margin formula calculating my profit margin. This formula looks like this =(Description5 - Description7) / Description5

When the sale price and landed cost are zero. I want my margin calculation to show 0% instead of #Divide By Zero.

I know I need to use If Error formula but I ma not sure how this needs to be combined with my current formula.

Find more posts tagged with

Accepted answers

Lachlan Stead

Hello Cody,

Should be as simple as this:

=IFERROR((Description5 - Description7) / Description5),0)

All comments

Lachlan Stead

Hello Cody,

Should be as simple as this:

=IFERROR((Description5 - Description7) / Description5),0)

Cody_Gomez32

Thank you for your reply. That worked how I needed it to.

Lachlan Stead

Good to hear!

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.