=BENUM (Between or Equal To Numbers)
The =BENUM function allows you to compare a number to see if it is between two other numbers or equal to either number.
Syntax
Section titled “Syntax”=BENUM(IsThisNum; GreaterThanOrEqualToThisNum; AndLessThanOrEqualToThisNum)Parameters
Section titled “Parameters”-
IsThisNum
- The number being evaluated.
-
GreaterThanOrEqualToThisNum
- The lower boundary number that IsThisNum must be greater than or equal to.
-
AndLessThanOrEqualToThisNum
- The upper boundary number that IsThisNum must be less than or equal to.
How It Works
Section titled “How It Works”-
The function checks whether IsThisNum is greater than or equal to the first comparison number and less than or equal to the second comparison number.
-
If both conditions are met, the function returns 1 (true).
-
If either condition is not met, the function returns 0 (false).
Usage Notes
Section titled “Usage Notes”-
Only numeric values are supported.
-
Boundary values are included in the comparison.
-
This function is useful for inclusive numeric range checks in conditional logic and workflows.
Example
Section titled “Example”=BENUM(223; 223; 240)- Returns: 1 (true)
Keywords
Section titled “Keywords”BENUM, inclusive number comparison, between or equal numbers, numeric range check, formula function, conditional logic, workflow formulas, number validation