Manuals/calci/BETWEEN

BETWEEN (Value,FirstValue,SecondValue)

• Failed to parse (MathML with SVG or PNG fallback (recommended for modern browsers and accessibility tools): Invalid response ("Math extension cannot connect to Restbase.") from server "https://wikimedia.org/api/rest_v1/":): {\displaystyle Value} Specifies an number to evaluate.
• Failed to parse (MathML with SVG or PNG fallback (recommended for modern browsers and accessibility tools): Invalid response ("Math extension cannot connect to Restbase.") from server "https://wikimedia.org/api/rest_v1/":): {\displaystyle FirstValue} Specifies the lower value in the range.
• Failed to parse (MathML with SVG or PNG fallback (recommended for modern browsers and accessibility tools): Invalid response ("Math extension cannot connect to Restbase.") from server "https://wikimedia.org/api/rest_v1/":): {\displaystyle SecondValue} Specifies the upper value in the range.

Description

• This function returns the logical value either true or false.
• BETWEEN(Value,FirstValue,SecondValue),in this Value is the number to find value is in between or not.
• First value specifies lower value in the range and Second value is the Upper value in the range.
• Between will return as TRUE if the given value is between the first and second value.And it return as FALSE if the given value is not between the first and second value.

Examples

1. BETWEEN(10,2,20) =true
2. BETWEEN(69,15,60) = false
3. BETWEEN(-6,-10,9) = true

See Also

• COUNTA
• COUNTIF

References

Between

• List of Main Z Functions

• Z3 home