Need a condition to override other conditions in a formula

Hello,

I need to show a percentage rate in one column based on a time of year in a different column, however, if there is a certain word in a third column, I need it to override the other conditions.

Right now, the formula is: =IF([Program Term]@row = "Summer", 0.325, IF([Program Term]@row = "Academic Year", 0.499))

I need to add IF([Rank]@row = "Retiree", 0.33 and make it override the others.

Thanks!

Find more posts tagged with

Formulas

Accepted answers

Paul Newcome

You would continue with a nested IF statement (add in a third IF), but you would want the highest priority to be first when reading from left to right.

All comments

Paul Newcome

You would continue with a nested IF statement (add in a third IF), but you would want the highest priority to be first when reading from left to right.

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.