Checks if a value is a logical value (TRUE or FALSE) and returns TRUE or FALSE.
الصيغة
ISLOGICAL(value)المعاملات
valueمطلوب
The value you want to test.
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)→TRUEReturns TRUE because TRUE is a logical value.
=ISLOGICAL("TRUE")→FALSEReturns FALSE because "TRUE" is treated as text, not a logical value.
Select a cell
Click on the cell where you want to display the result.
Enter the formula
Type =ISLOGICAL(A1) and press Enter, replacing A1 with the cell containing the value you want to check.
No, ISLOGICAL only returns TRUE for the logical values TRUE and FALSE.