Nested IF Function Help

I am struggling to get this formula to work. Any thoughts?

=IF(([FY26 Membership Level]@row = "Basic", "$2,000", IF[FY26 Membership Level]@row="Enhanced Level 1", "$8,000", IF[FY26 Membership Level]@row="Enhanced Level 2", "$12,000", IF[FY26 Membership Level]@row="Intensive Level 1", "$15,000",IF[FY26 Membership Level]@row="Intensive Level 2", "$24,000"),"$0")

Find more posts tagged with

Accepted answers

ECarlson_PCG

=IF([FY26 Membership Level]@row = "Basic", "$2,000", IF([FY26 Membership Level]@row="Enhanced Level 1", "$8,000", IF([FY26 Membership Level]@row="Enhanced Level 2", "$12,000", IF([FY26 Membership Level]@row="Intensive Level 1", "$15,000", IF([FY26 Membership Level]@row="Intensive Level 2", "$24,000", "$0")))))

^ Added a space before the last "IF" to this version and moved the closing ).
Additional question: is it finding the correct column reference when you add the formula to your sheet? All the "[FY26 Membership Level]@row" references become colors?

All comments

ECarlson_PCG

You're missing some ( after the IF in the nested IFS of your formula. Update for you below.

What do you want to accomplish at the end? All IFs, otherwise "$0"? written as such:

=IF([FY26 Membership Level]@row = "Basic", "$2,000", IF([FY26 Membership Level]@row="Enhanced Level 1", "$8,000", IF([FY26 Membership Level]@row="Enhanced Level 2", "$12,000", IF([FY26 Membership Level]@row="Intensive Level 1", "$15,000",IF([FY26 Membership Level]@row="Intensive Level 2", "$24,000")))),"$0")

dgarnas

Thank you ECarlson! I tried your formula, I got the error "Incorrect Argument Set". Yes, all IFs otherwise "$0", to answer your question. Any other ideas?

ECarlson_PCG

dgarnas

This worked, thank you so much ECarlson!!

ECarlson_PCG

Oh great! Glad 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.