bool()

Read(268) 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

 

 

2

=bool(123)

True

3

=bool(A1)

False