# ISLOGICAL

The `ISLOGICAL` 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.

## Usage

Use the `ISLOGICAL` formula with the syntax shown below, it has 1 required parameter:

Parameters:
1. 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 the `ISLOGICAL` 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 non-boolean value as the argument. The ISLOGICAL function only works with boolean values (TRUE or FALSE). Double-check 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. Double-check 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.

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 non-numeric 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 non-text values.

• `ISBLANK`

The `ISBLANK` formula is used to check if a cell is empty. It returns `TRUE` if the cell is empty and `FALSE` 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 as `AND`, to build more complex logical statements.

You can learn more about the `ISLOGICAL` Google Sheets function on Google Support.