bool()

Read(437) 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.

Parameters:

expression

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

Retrun value:

True/False

Example:

 

A

 

1

=bool(123)

true

2

=bool(A1)

true

3

=bool("false")

false