Checks if a value is a logical value (TRUE or FALSE) and returns TRUE or FALSE.
Diese Funktion funktioniert in Google Sheets genauso wie in Excel — gleiche Syntax und Argumente.
ISLOGICAL(value)The ISLOGICAL function is part of the IS family of functions. It returns TRUE if the provided value is a logical value, and FALSE if it is any other type of data, such as a number, text, or error.
=ISLOGICAL(TRUE)Ergebnis: TRUE
Returns TRUE because TRUE is a logical value.
=ISLOGICAL("TRUE")Ergebnis: FALSE
Returns FALSE because "TRUE" is treated as text, not a logical value.
No, ISLOGICAL only returns TRUE for the logical values TRUE and FALSE.