Formula Consolidation

Jen Castillo

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. :)

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

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