ISLOGICAL

This function tests whether a value, an expression or the contents of a referenced cell is a logical (Boolean) value.

Syntax

ISLOGICAL(cellreference)

ISLOGICAL(value)

ISLOGICAL(expression)

Arguments

[Required] Specify a cell reference, a numeric or text value, or an expression for the argument.

Remarks

This function returns FALSE if the value refers to an empty cell or no data.

Use this function to test the contents of a cell, a numeric or text value directly, or a function or expression.

Examples

ISLOGICAL(B7)

ISLOGICAL(R4C8)

ISLOGICAL(true) gives a result TRUE

ISLOGICAL(OR(B7,B8)) gives a result FALSE