# Excel ISLOGICAL function

## Summary

The Excel ISLOGICAL function checks if a specific cell contains a logical value, TRUE or FALSE. This function is particularly useful in scenarios where you’re analyzing data that includes logical conditions or outcomes, enabling you to distinguish between cells with logical values and those with other types of data.
##### Syntax
```				```
=ISLOGICAL(value)
```
```
• value: The cell reference or value you want to test for a logical value
##### Return value
• TRUE if the specified cell contains a logical value (TRUE or FALSE)
• FALSE if the cell contains any other type of data

## How to use

ISLOGICAL is simple to use: just provide the cell reference or value you wish to test. It can be effectively combined with other functions, such as IF, to execute conditional logic based on the presence of logical values in your data.

## Examples

##### Simple ISLOGICAL
Checking for Logical Values in a Cell: To verify if a cell, for example, A1, contains a logical value.
```				```
=ISLOGICAL(A1)

```
```
If A1 contains either TRUE or FALSE, this formula returns TRUE, indicating the cell holds a logical value. If A1 contains text, numbers, or any other type of data, it returns FALSE.
##### ISLOGICAL with Conditional Logic
Implementing Conditional Formatting Based on Logical Values: Using ISLOGICAL within an IF statement to display messages based on the type of data.
```				```
=IF(ISLOGICAL(A1), "Logical value detected", "Not a logical value")

```
```
This formula checks A1 for a logical value and returns “Logical value detected” if found; otherwise, it indicates “Not a logical value.”
##### ISLOGICAL in Data Validation
Filtering Data Based on Logical Values: To filter or validate data entries that must be logical values.
```				```
=ISLOGICAL(B2:B100)

```
```
Applying ISLOGICAL across a range can help in scenarios where you need to ensure that a series of cells only contain logical values, aiding in data consistency and validation.