Multiple IF functions Nested

Hello,

I would like to Nest two If functions in one cell. Below is what I have, but I am receiving an error #unparseable.

=IF([Sales Person 1]2667 = "Y", ([Net Profit]2667 - 100) * 0.5, IF([Commission due]2667 > 0, "0" )), ([Net Profit]2667 - 100) * 0.4)

I would greatly appreciate your help.

Thank you.

Find more posts tagged with

Accepted answers

Paul Newcome

Which column are you putting your formula in?

All comments

Mathieu PERSICO

Hi @Yeshaya,

A misplaced parenthesis. Try this:

=IF([Sales Person 1]2667 = "Y", ([Net Profit]2667 - 100) * 0.5, IF([Commission due]2667 > 0, "0", ([Net Profit]2667 - 100) * 0.4))

Have a good day,

Yeshaya

I tried it, however I get an error "#Circular Ref"

Paul Newcome

Which column are you putting your formula in?

Yeshaya

You ar correct. It was placed in the wrong column. Now it works!

Thank you very much!

Paul Newcome

Happy to 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, latest, sort, sortType, lookupSort, discussion, discussion/name, tags, breadcrumbs, discussionApiParams, serverDraftID, serverDraft.