Description:
Convert a data object to a Boolean value.
Syntax:
bool(expression)
Note:
The function converts the data type of a given expression expression to a Boolean type. It returns false when the parameter value is null, “false” (case-sensitive), and false; otherwise, it returns true.
Parameter:
|
expression |
A constant or an expression. |
Return value:
|
|
A |
|
|
1 |
=bool(123) |
true |
|
2 |
=bool(A1) |
true |
|
3 |
=bool("false") |
false |
|
4 |
=bool(1==2) |
false |
|
5 |
=bool(null) |
false |