bool()

Read(2193) Label: convert, boolean value,

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, the string “false” (case-sensitive), and the Boolean value false; otherwise, it returns true.

Parameter:

expression

A constant or an expression that you want to convert to a Boolean value

Return value:

Boolean value

Example:

 

A

 

1

=bool(123)

true

2

=bool(A1)

true

3

=bool("false")

false