IF AND trouble

ethompson

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 didn’t work

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

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

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

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

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

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

How can I fix this?  Thank you!

Mike Wilday

Try this, it appears you were very close in several options but also had other issues. You need to close the AND statement before providing the then statement... 

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

According to the AND formula, you state your criterion, add a comma, then state your next criteria, and so forth and so on, then you have to close it. 

There are some examples at the following article to look at.:

https://help.smartsheet.com/function/and