How to identify if a number falls between two other numbers

A Hannagan
edited 01/17/24 in Formulas and Functions


I am trying to determine how to capture if a number falls between two other numbers. The numbers vary on each row. Example:

=IF([Column22]@row >= 9, "1", IF([Column23]@row >= 9, "1"))

Column 22 is 4 and Column 23 is 7. It works find here, but I also need this formula to provide a "0" or blank for if the number is less than 4. Example:

=IF([Column22]@row >= 3, "1", IF([Column23]@row >= 3, "1"))

How can I make the formula understand the OR piece of this formula?


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!