The ISLOGICAL function in Google Sheets is **useful when you need to check if a given cell contains a boolean value.**

Boolean values are denoted by either a ‘TRUE’ or ‘FALSE’ string, a checkbox, or a logical test output.

##### Table of Contents

The rules for using the ISLOGICAL function in Google Sheets are as follows:

- The function requires a single cell with the value to verify as a boolean.
- The function then outputs TRUE or FALSE depending on whether the given value is a boolean.

Let’s take a look at a brief example!

In this example, we have a dataset of values that requires some data cleaning. Data cleaning is an important part of data analysis. This process involves detecting and correcting incomplete or inaccurate values in datasets. For example, rows with missing values can be filtered out or have those missing values filled with some specified value (like 0 or the mean of that given column).

Our dataset contains a column that requires every value to be a boolean. How do we make sure that each row in our dataset has a valid boolean value?

With the `ISLOGICAL`

function it becomes quite easy to flag invalid boolean values. We can expand further on this function and perform specific operations on invalid values, or simply filter them out altogether.

Now that we know one common use-case of the `ISLOGICAL`

function, let’s learn how to use it and work on an actual sample spreadsheet.

**The Anatomy of the ISLOGICAL Function**

So the syntax (the way we write it) of the `ISLOGICAL`

function is as follows:

=ISLOGICAL(value)

Let’s dissect this formula and understand what each of these terms means:

**=**the equal sign is how we start any function in Google Sheets.**ISLOGICAL()**is our`ISLOGICAL`

function. It returns whether the value of a given cell is`TRUE`

or`FALSE`

.**value**is the sole argument of the`ISLOGICAL`

function. It may be a value, or a reference to another cell.- The
`ISLOGICAL`

function is often used together with the`IF`

function in conditional statements.

**A Real Example of Using ISLOGICAL Function**

Let’s look into an example of the `ISLOGICAL`

function being used in a Google Sheets spreadsheet.

In the example below, we have multiple types of values in Column A. If we only want to get values that correspond to either `TRUE`

or `FALSE`

, we can use the `ISLOGICAL`

function.

To get the values in Column B, we just need to use the following formula:

=ISLOGICAL(A2)

You can make your own copy of the sample spreadsheet above using the link attached below.

We can also use the `ISLOGICAL`

function in Google Sheets in conjunction with other functions.

In the sample table below, we have a dataset where each row has a unique ID. Let’s say we would like to only see the IDs of rows with a valid boolean value. We can use the `FILTER`

function with the `ISLOGICAL`

function to return the list of valid IDs in column E.

If you’re ready to test the `ISLOGICAL`

function in Google Sheets, we can start writing it ourselves using the guide in the next section!

**How to Use ISLOGICAL Function in Google Sheets**

- First, select the cell we will be typing our formula in. In this example, we’ll start with cell
**B2.**

- In our next step, we just have to type the equal sign ‘
**=**‘ to begin our function, followed by ‘**ISLOGICAL(**‘. - A tooltip box may appear showing information on the
`ISLOGICAL`

function. We can click the arrow on the top-right-hand corner of the box to minimize it if needed.

- Next, we need to type in the value we’ll be verifying with the
`ISLOGICAL`

function. In this case, we can just use a reference to cell**A2**. Afterward, simply hit the**Enter**key on your keyboard to let the function evaluate.

- Finally, we can drag down the formula to fill out the rest of the column!

**Frequently Asked Questions (FAQ)**

**How do I let the ISLOGICAL function return an integer value instead?**

In case you need to return the result of the`ISLOGICAL`

function as an integer, we can simply use the following modified formula:

**=–ISLOGICAL(value)****How do I add a checkbox to my sheet?**

Checkboxes are an easy way to make it easy for users to change the Boolean value of a cell. After selecting which cells we want to add checkboxes to, just click**Insert**and then click**Checkbox**to add one to all selected cells.

This step-by-step guide shows how simple it is to determine whether a given value or cell has a Boolean value of TRUE or FALSE.

We can now use the ISLOGICAL functions in Google Sheets together with the various other Google Sheets formulas available to create great worksheet solutions.

Don’t miss staying up-to-date on our new guides by subscribing to our newsletter!