ISBOOLEAN

Returns true if the value is a boolean value (true or false).

Syntax

=ISBOOLEAN(value, fuzzy)

Arguments

ArgumentTypeDescription
valueAnyThe value to test
fuzzyBooleanSpecify whether the test should allow conversion

Examples

=ISBOOLEAN(false)true
Tests whether the value false is a boolean.

=ISBOOLEAN(1, true)true
Tests whether the number 1 is a boolean with fuzzy matching.

=ISBOOLEAN(123)false
Tests whether the number 123 is a boolean.