Checks if a value is a logical value (TRUE or FALSE) and returns TRUE or FALSE.
この関数は Google スプレッドシートでも Excel と同じように機能します。構文も引数も同じです。
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)結果: TRUE
Returns TRUE because TRUE is a logical value.
=ISLOGICAL("TRUE")結果: 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.