ISBETWEEN

Checks whether a provided number is between two other numbers either inclusively or exclusively.

Parts of a ISBETWEEN function

ISBETWEEN(value_to_compare, lower_value, upper_value, lower_value_is_inclusive, upper_value_is_inclusive)

Part

Description

value_to_compare

The value to test as being between `lower_value` and `upper_value`.

lower_value

The lower boundary of the range of values that `value_to_compare` can fall within.

upper_value

The upper boundary of the range of values that `value_to_compare` can fall within.

lower_value_is_inclusive [optional]

Whether the range of values includes the `lower_value`. By default this is TRUE

upper_value_is_inclusive [optional]

Whether the range of values includes the `upper_value`. By default this is TRUE

 

Examples

Short description of the example being shown below. Feel free to add more rows and columns to the table below if needed.

 

FORMULA

OUTPUT

=ISBETWEEN(7.9, 1.2, 12.45)

TRUE

=ISBETWEEN(1.2, 1.2, 12.45, TRUE)

TRUE

=ISBETWEEN(1.2, 1.2, 12.45, FALSE)

FALSE

=ISBETWEEN(12.45, 1.2, 12.45, TRUE, TRUE)

TRUE

=ISBETWEEN(12.45, 1.2, 12.45, TRUE, FALSE)

FALSE

=ISBETWEEN(7.9, 1.2, 12.45, FALSE, FALSE)

TRUE

 

Related functions

Was this helpful?
How can we improve it?
true
Visit the Learning Center

Using Google products, like Google Docs, at work or school? Try powerful tips, tutorials, and templates. Learn to work on Office files without installing Office, create dynamic project plans and team calendars, auto-organize your inbox, and more.

Search
Clear search
Close search
Google apps
Main menu
Search Help Center
true
35
false