IF AND trouble

ethompson
ethompson
edited 12/09/19 in Smartsheet Basics

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!

SS.jpg

Comments

  • Mike Wilday
    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