Formula Consolidation

This was originally a checkbox column to see if an estimated was within a 10% margin on either side, but now I need it to account for if it is under/over the 10%.

Currently, three checkbox columns exist, with the following formulas:

EST GOOD -

=IF(AND([HR PER UNIT / EST]@row > [10% DOWN]@row, [HR PER UNIT / EST]@row < [10% UP]@row), 1, 0)

EST LOW -

=IF([HR PER UNIT / EST]@row < [10% DOWN]@row, 1, 0)

EST HIGH -

=IF([HR PER UNIT / EST]@row > [10% UP]@row, 1, 0)

I want to consolidate this into a single dropdown column using the RED/YELLOW/GREEN symbols, but I keep messing up my syntax. Hoping someone can help!

Thanks in advance. :)

Find more posts tagged with

Formulas

Accepted answers

Leibel S

Does this work?

=IF([HR PER UNIT / EST]@row > [10% UP]@row, 1, IF([HR PER UNIT / EST]@row < [10% DOWN]@row, 1,IF(AND([HR PER UNIT / EST]@row > [10% DOWN]@row, [HR PER UNIT / EST]@row < [10% UP]@row), 1, 0)))

All comments

Leibel S

Does this work?

=IF([HR PER UNIT / EST]@row > [10% UP]@row, 1, IF([HR PER UNIT / EST]@row < [10% DOWN]@row, 1,IF(AND([HR PER UNIT / EST]@row > [10% DOWN]@row, [HR PER UNIT / EST]@row < [10% UP]@row), 1, 0)))

Jen Castillo

I'm using this for a drop down with symbols but you helped me figure out where my syntax was wrong. Thank you!

Humashankar

Perfect

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.