bool ()

Read(1893) 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:

True/False

Example:

 

A

 

1

=bool(123)

true

2

=bool(A1)

true

3

=bool("false")

false