# IF AND OR Formula Help

Options

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

• ✭✭✭✭✭✭
Options

Excellent!

SMARTSHEET EXPERT CONSULTANT & PARTNER

Andrée Starå | Workflow Consultant / CEO @ WORK BOLD

W: www.workbold.com | E:andree@workbold.com | P: +46 (0) - 72 - 510 99 35

Feel free to contact me for help with Smartsheet, integrations, general workflow advice, or anything else.

• Options

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"))))

• ✭✭✭✭
Options

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

• ✭✭✭✭✭✭
Options

Excellent!

SMARTSHEET EXPERT CONSULTANT & PARTNER

Andrée Starå | Workflow Consultant / CEO @ WORK BOLD

W: www.workbold.com | E:andree@workbold.com | P: +46 (0) - 72 - 510 99 35

Feel free to contact me for help with Smartsheet, integrations, general workflow advice, or anything else.

## Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!