=BNUM (Between Numbers)
The =BNUM function allows you to compare a number to see if it is between two other numbers.
Syntax
Section titled “Syntax”=BNUM(IsThisNum; GreaterThanThisNum; AndLessThanThisNum)Parameters
Section titled “Parameters”-
IsThisNum
- The number being evaluated.
-
GreaterThanThisNum
- The lower boundary number that IsThisNum must be greater than.
-
AndLessThanThisNum
- The upper boundary number that IsThisNum must be less than.
How It Works
Section titled “How It Works”-
The function checks whether IsThisNum is greater than the first comparison number and less than 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 not included in the comparison.
-
This function is useful for exclusive numeric range checks in conditional logic and workflows.
Example
Section titled “Example”=BNUM(223; 220; 240)- Returns: 1 (true)
Keywords
Section titled “Keywords”BNUM, number comparison, between numbers, exclusive numeric range, formula function, conditional logic, workflow formulas, number validation