ISLOGICAL
TheISLOGICAL
formula is used to check if a value is a logical value (TRUE or FALSE). If the value is a logical value, the formula returns TRUE. If the value is not a logical value, the formula returns FALSE.
 How to use
ISLOGICAL
formula?  Examples of using
ISLOGICAL
formula ISLOGICAL
formula not working? Similar formulas to
ISLOGICAL
Usage
Use the ISLOGICAL
formula with the syntax shown below, it has 1 required parameter:
 value (required):
The value to check if it is a logical value. It can be a reference to a cell containing a logical value or a logical expression.
Examples
Here are a few example use cases that explain how to use theISLOGICAL
formula in Google Sheets.
Check if a value is a logical value
The ISLOGICAL
formula can be used to check if a value is a logical value. For example, it can be used to verify if a cell contains a TRUE or FALSE value.
Combine with other logical formulas
The ISLOGICAL
formula can be combined with other logical formulas to create more complex formulas. For example, it can be used with the AND
or OR
formulas to check if multiple values are logical values.
Filter data based on logical values
The ISLOGICAL
formula can be used to filter data based on logical values. For example, it can be used with the FILTER
formula to extract all rows that contain TRUE or FALSE values.
Common Mistakes
ISLOGICAL
not working? Here are some common mistakes people make when using the ISLOGICAL
Google Sheets Formula:
Incorrect argument type
One common mistake is to provide a nonboolean value as the argument. The ISLOGICAL function only works with boolean values (TRUE or FALSE). Doublecheck that the value you are testing is a boolean value.
Missing argument
Another common mistake is forgetting to provide an argument to the ISLOGICAL function. Make sure there is a value between the parentheses.
Misspelling function name
A common mistake is misspelling the name of the function. Doublecheck that you have spelled ISLOGICAL correctly.
Mistakenly using as a test function
One mistake is to use ISLOGICAL as a test function instead of a logical function. ISLOGICAL returns a boolean value indicating whether the input is a boolean or not, it does not test whether a value is true or false. Check that you are using the function correctly.
Not using output correctly
One common mistake is not using the output of the ISLOGICAL function correctly. Remember that ISLOGICAL returns a boolean value, so it should be used in a context that expects a boolean value, such as an if statement or logical comparison.
Related Formulas
The following functions are similar to ISLOGICAL
or are often used with it in a formula:

ISNUMBER
The
ISNUMBER
formula is used to check if a given value is a number. It returns TRUE if the value is a number and FALSE if it is not. This formula is commonly used in data cleaning and validation to identify and remove nonnumeric values or to ensure that a cell only contains a number. 
ISTEXT
The
ISTEXT
function checks whether the value provided is a text string or not. It returns TRUE if the value is text and FALSE if it is any other data type. This function is commonly used when working with data sets that contain text and nontext values. 
ISBLANK
The
ISBLANK
formula is used to check if a cell is empty. It returnsTRUE
if the cell is empty andFALSE
if it contains any data or formula. This formula is commonly used in conditional formatting or data validation rules to ensure a cell is not left empty. 
AND
The
AND
function in Google Sheets is a logical function that returns TRUE if all of the logical expressions in the argument are TRUE, and FALSE if any of the logical expressions are FALSE. It can be used to test multiple conditions and evaluate whether they are all true or not. 
OR
The
OR
formula is a logical formula that returns TRUE if at least one of the provided logical expressions is TRUE. It returns FALSE if all logical expressions are FALSE. This formula is commonly used in conjunction with other logical formulas, such asAND
, to build more complex logical statements.
Learn More
You can learn more about the ISLOGICAL
Google Sheets function on Google Support.