My Formula looks incorrect

Hello,

I am attempting to get a Margin (%) for my outcome, however I have received "unparseable", "incorrect argument" "invalid" when attempting a few variations. Am I overlooking something?

I need to get my

The formula I am using in smartsheet:

=IF(ISBLANK([Customer Cost/Booking $$]@row - [Partner Cost $$]@row), "", /[Customer Cost/Booking $$])

So that the outcome would be in the margin column:

Thank you!!

Find more posts tagged with

Formulas

Accepted answers

Adriane Price

Thank you, the below formula ended up working for my situation

=IFERROR(SUM([Customer Cost/Booking $$]@row - [Partner Cost $$]@row) / [Customer Cost/Booking $$]@row, 0)

All comments

J Tech

Try this one

=IF([Customer Cost/Booking $$]@row="","",([Customer Cost/Booking $$]@row - [Partner Cost $$]@row), "", /[Customer Cost/Booking $$])

Adriane Price

Thank you, the below formula ended up working for my situation

=IFERROR(SUM([Customer Cost/Booking $$]@row - [Partner Cost $$]@row) / [Customer Cost/Booking $$]@row, 0)

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.