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.:
Categories
 All Categories
 14 Welcome to the Community
 Smartsheet Customer Resources
 62.3K Get Help
 364 Global Discussions
 200 Industry Talk
 428 Announcements
 4.4K Ideas & Feature Requests
 136 Brandfolder
 127 Just for fun
 128 Community Job Board
 445 Show & Tell
 28 Member Spotlight
 1 SmartStories
 283 Events
 35 Webinars
 7.3K Forum Archives