deepcalc
DocsISBETWEEN

ISBETWEEN

View as markdown/docs/functions/isbetween.md Ask Claude about this pageOpens Claude with this page's address

True when a number lies within a range.

  • Excel: No equivalent
  • Google Sheets: Not checked yet
  • Returns: Boolean

Examples

=ISBETWEEN(5, 1, 10)
Result true

Syntax

ISBETWEEN(value, low, high, [low_inclusive], [high_inclusive])
value
number required
low
number required
high
number required
low_inclusive
boolean optional defaults to 1
high_inclusive
boolean optional defaults to 1

Errors

#VALUE!
=ISBETWEEN("alpha", 2, 2)
ANDReturns TRUE if all arguments are true. EQTrue when two values are equal. FALSEReturns the logical value FALSE. GTTrue when the first number is greater. GTETrue when the first number is greater or equal. IFReturns one value if condition is true, another if false.