IF AND trouble
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!
Comments
-
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.:
