ISBOOLEAN
Returns true if the value is a boolean value (true or false).
Syntax
=ISBOOLEAN(value, fuzzy)
Arguments
Argument | Type | Description |
---|---|---|
value | Any | The value to test |
fuzzy | Boolean | Specify 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.
Updated 9 months ago