IF AND OR Formula Help

Hello!

We are building a questionnaire that shows the results of a leadership style. The formula that we are trying is:

=IF([Total Value - Even]@row >= 10, IF([Total Value - Odd]@row >= 10, "Coaching", IF([Total Value - Even]@row >= 10, IF([Total Value - Odd]@row <= 9, "Directing", IF([Total Value - Even]@row <= 9, IF([Total Value - Odd]@row <= 9, "Entrusting", IF([Total Value - Even]@row <= 9, IF([Total Value - Odd]@row >= 10, "Supporting", "0"))))))))

The second half works by itself, but not with the first half because of duplicate statements. Here is the sheet:

I have summed the responses in the "Total Value Even" and "Total Value Odd" columns. The Leadership style is determined by the values outlined in the "Formula Variables" column.

Thank you!

Kerron

Find more posts tagged with

Accepted answers

Andrée Starå

@KERRON MITCHELL

Excellent!

Glad you got it working!

✅Please support the Community by marking your post with the accepted answer/helpful. It will make it easier for others to find a solution or help to answer!

All comments

Kerron Mitchell

This is what worked after more trial and error!

=IF(AND([Total Value - Even]@row >= 10, [Total Value - Odd]@row >= 10), "Coaching", IF(AND([Total Value - Even]@row >= 10, [Total Value - Odd]@row <= 9), "Directing", IF(AND([Total Value - Even]@row <= 9, [Total Value - Odd]@row <= 9), "Entrusting", IF(AND([Total Value - Even]@row <= 9, [Total Value - Odd]@row >= 10), "Supporting", "0"))))

Joseph Gentile

Hi @KERRON MITCHELL ,

Looks like you figured this problem out, and I concur with your formula. Just needed to make it an If(AND( function. 👍️

Andrée Starå

@KERRON MITCHELL

Excellent!

Glad you got it working!

✅Please support the Community by marking your post with the accepted answer/helpful. It will make it easier for others to find a solution or help to answer!

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.