Checks if a value is a logical value (TRUE or FALSE) and returns TRUE or FALSE.
פונקציה זו פועלת ב-Google Sheets בדיוק כמו ב-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.