Checks if a value is a logical value (TRUE or FALSE) and returns TRUE or FALSE.
Questa funzione funziona in Google Sheets esattamente come in Excel — stessa sintassi e stessi argomenti.
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)Risultato: TRUE
Returns TRUE because TRUE is a logical value.
=ISLOGICAL("TRUE")Risultato: 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.