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 6 months ago