1

I am trying to create a formula that assigns "Yes" to a cell if a result is within range and "No" if it is not.  This formula worked for only one of the columns in the range:

=IF([High Control Result]1 > [High Control Range Minimum]1, "Yes", "No")

I tried to use AND without success:

These formulas