How to identify if a number falls between two other numbers

Hello,

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?

Find more posts tagged with

Accepted answers

All comments

John Shane

@A Hannagan

I want to make sure I understand your problem. Are you trying to return a "1" if the value is greater than or equal to 4 and less than or equal to 9, and a "0" if it falls outside that range?

John

A Hannagan

@John Shane Yes, exactly.

John Shane

@A Hannagan

This formula will evaluate the four criteria and return a 0 if any are true. If all are false (number is between 4 and 9), it will return a 1. Hope this helps.

=IF(OR([Column22]@row > 9, [Column23]@row > 9, [Column22]@row < 4, [Column23]@row < 4), 0, 1)

Cheers,

John

A Hannagan

@John Shane Thank you! That works.

Now, if I need to know if certain numbers fall within that range, can I do that? Example, I need to know if 3 falls between the numbers in Column 22 and Column 23 or if 8 falls between the numbers in Column 22 or Column 23. In the snippet below, I want a 1 in the columns under 3, 4, 5, 6, etc if they that number falls between the range of numbers in Column 22:Column 23.

Sign in to join the conversation!

Quick Links

Component react.discussion.discussions had an error.

ref must be one of: categoryID, siteSectionID, category, category/categoryID, category/name, category/description, category/url, category/allowedDiscussionTypes, locale, siteSection, siteSection/basePath, siteSection/contentLocale, siteSection/sectionGroup, siteSection/sectionID, siteSection/name, siteSection/description, siteSection/apps, siteSection/attributes, layoutViewType, discussionID, commentID, page, sort, discussion, discussion/name, tags, breadcrumbs, discussionApiParams, serverDraftID, serverDraft.