How do I create a multiple IF statement?

I'd like to create an IF statement with multiple questions to determine how close to the next level group. If less than 25, what is the number. If more than 25, 50 - #, etc.

=IF([Sponsor Level total]@row <25, (25-[Sponsor Level total]@row, IF[Sponsor Level total]@row<50, (50-[Sponsor Level total]@row, IF[Sponsor Level total]@row<100, (100-[Sponsor Level total]@row))))

Find more posts tagged with

Accepted answers

Paul Newcome

You have some misplaced parenthesis.

=IF([Sponsor Level total]@row <25, 25-[Sponsor Level total]@row, IF([Sponsor Level total]@row<50, 50-[Sponsor Level total]@row, IF([Sponsor Level total]@row<100, 100-[Sponsor Level total]@row)))

All comments

Paul Newcome

You have some misplaced parenthesis.

=IF([Sponsor Level total]@row <25, 25-[Sponsor Level total]@row, IF([Sponsor Level total]@row<50, 50-[Sponsor Level total]@row, IF([Sponsor Level total]@row<100, 100-[Sponsor Level total]@row)))

Morgan Marquez

Hi there!

Are you able to elaborate on your question a little bit?

Janey Morton

Thank you so much. Putting the parenthesis is the right spot worked perfectly.

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.