How To Use ISLOGICAL Function in Google Sheets

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.

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.

Using ISLOGICAL Function in Google Sheets to detect whether values are boolean values

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.

Using ISLOGICAL and FILTER to return only values with booleans

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

  1. First, select the cell we will be typing our formula in. In this example, we’ll start with cell B2.
    Selecting a cell to put our ISLOGICAL Function in Google Sheets

  2. In our next step, we just have to type the equal sign ‘=‘ to begin our function, followed by ‘ISLOGICAL(‘. 
  3. 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.
    Typing our ISLOGICAL Function into the Formula Bar

     
  4. 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.
    Adding a cell reference as an argument to our ISLOGICAL Function in Google Sheets

  5. Finally, we can drag down the formula to fill out the rest of the column!
    Filling our column with the results of our ISLOGICAL function

 

 

Frequently Asked Questions (FAQ)

  1. 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) 
  2. 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.
    We can add checkboxes as an alternate way to add Boolean values to our spreadsheet

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

Get emails from us about Google Sheets.

Our goal this year is to create lots of rich, bite-sized tutorials for Google Sheets users like you. If you liked this one, you'd love what we are working on! Readers receive ✨ early access ✨ to new content.

 

0 Shares:
Leave a Reply

Your email address will not be published. Required fields are marked *

You May Also Like