What is ISLOGICAL Function in Google Sheets?
The ISLOGICAL function in Google Sheets is used to find whether a value is TRUE or FALSE. If it is a logical value, the function returns TRUE. If it is not a logical value, it returns FALSE. From evaluating survey responses to tracking inventory, ISLOGICAL in Google Sheets helps you maintain reliable datasets. Often, ISLOGICAL is used with the IF function to find the results of complex formulas with conditions. ISLOGICAL is helpful as it can help clean up your data, helping you identify cells that contain unexpected values.
If you have a list of values in column A, you want to check if each value is logical (TRUE or FALSE). Let us see the outcome of this function. We have applied the function for the values in cells A1 to A4. You can observe that the result of ISLOGICAL is TRUE for the Boolean values and FALSE otherwise.
The ISLOGICAL function is often used with the IF function in conditional statements. For example, the IF function returns one value if a logical expression is TRUE and another if it is FALSE.
Key Takeaways
- The ISLOGICAL function in Google Sheets checks whether a given value is either TRUE or FALSE logical values. It returns TRUE if the value is logical, and FALSE otherwise.
- The syntax of ISLOGICAL in Google Sheets is:
=ISLOGICAL(value). Here, value is the argument supplied which can be a cell reference, a direct logical value, or a formula.
- ISLOGICAL can be used in conjunction with other logical functions like AND, IF, or OR to work on cells that contain logical values.
- The ISLOGICAL formula is not case sensitive; however, it does not recognize string values of TRUE or FALSE.
Syntax
Let’s explore the details of using ISLOGICAL in Google Sheets. The syntax is straightforward, with a single argument.
=ISLOGICAL(value)
value – The value that we verify as a logical TRUE or FALSE.
ISLOGICAL returns TRUE if the value is either TRUE or FALSE. The input can also be a cell reference to any cell whose value is TRUE or FALSE.
How To Use ISLOGICAL Function in Google Sheets?
The ISLOGICAL function in Google Sheets can be entered in two ways.
- Manually enter the function
- Through the Google Menu Bar
To use the ISLOGICAL function in Google Sheets manually, follow these steps:
Step 1: To understand how to enter the function manually, open a Google Sheet and click on an empty cell where you want to display the result of the ISLOGICAL function.
Step 2: Type =ISLOGICAL( and then enter the value you want to test. You can also input a cell reference if you have the value in another cell.
Step 3: Close the parentheses and press Enter.
That’s how simple it is! If the cell contains a logical value, TRUE is displayed. Otherwise, you’ll see FALSE.
Examples
In this section, we will walk through the basics of how to use ISLOGICAL in Google Sheets. Let us explore some practical scenarios of ISLOGICAL in google sheets examples.
Example #1
In this example, we have some tasks for a project. The employees enter the status of completion, and we have to check if the status of completion amounts to TRUE or FALSE.
Look at the table below.
Step 1: Let us enter the following formula in cell C2.
=ISLOGICAL(IF(B2=”Completed”, TRUE, “Not completed”))
Explanation:
Here, in the inner IF function, we check if the status is entered as “Completed” by the employee. If so, we make the value TRUE. If the entered value is either “In Progress” or “Not Started,” it means the process is not yet completed. Hence, we make the value “Not Completed.”
The ISLOGICAL prints TRUE if completed and FALSE otherwise.
Step 2: Press Enter. The status will be “TRUE” as the value entered is “Completed.”
Step 3: Drag the formula for all the other tasks to check their completion status, as shown below.
Example #2 – Combining ISLOGICAL with IF Function
As discussed earlier, combining IF and ISLOGICAL produces the best results! Here’s an interesting example of using ISLOGICAL with IF based on a practical scenario.
You have a list of students, and their grades are mentioned as Pass or Fail. You want to validate whether the result column contains valid logical entries (TRUE for Pass, FALSE for Fail and provide the results to the students accordingly.
Step 1: Check if the value in the “Grades” column is A, B, C, or D.
Mark “Pass” in the “Status Feedback” column if it’s an A, B or C.
If it’s D, mark “Fail.”
=ISLOGICAL(IF(OR(B2=”A”, B2 = “B”, B2 = “C”), TRUE, “Fail”)
Explanation:
- OR(B2=”A”, B2 = “B”, B2 = “C”) – It checks if the value in cell B2 is either A, or B, or C.
- ISLOGICAL – it returns TRUE and FALSE based on the value in cell C2.
Press Enter.
Step 2: Drag the formula to the other students to get the result.
You can extend this concept to check other data entries and validate your dataset differently.
Example #3 – Using ISLOGICAL for Conditional Formatting
In Google Sheets, any number of cells, rows, or columns can be formatted based on certain conditions to change text or background color. Conditional formatting makes your data visually appealing and easier to understand. We can use ISLOGICAL with conditional formatting to highlight cells based on whether they contain logical values.
Let us proceed with the same. Look at the table below. Cells contain either TRUE, FALSE, or other values. Let us apply conditional formatting to the cells containing logical values.
Step 1: Select the range of cells you want to format. Here, it is A1:C5.
Step 2: Go to Format > Conditional formatting.
Step 3: Under “Format cells if”, choose “Custom formula is”.
Enter the following formula here.
=ISLOGICAL(A1:C5)
Choose a formatting style, which can be a background color or bold that will be applied to any logical values present.
Step 4: Click Done. Thus, all logical values in the selected range will be visible with the changes applied in conditional formatting, making it easier to spot patterns or errors.
Important Things to Note
- ISLOGICAL in Google Sheets can be used along with other logical functions like AND, IF, or OR to make the necessary changes when dealing with Boolean values.
- It is important to note that ISLOGICAL cannot work with the string values of “TRUE” or “FALSE.” but only with the Boolean TRUE and FALSE. The string versions are not recognized as logical values.
- The function treats the values TRUE and FALSE as logical values irrespective of their case. Therefore, ISLOGICAL is case-sensitive.
Frequently Asked Questions (FAQs)
Below is a list of functions similar to ISLOGICAL in Google Sheets.
1. ISTEXT: This function checks whether a value is text, returns TRUE if so, and FALSE otherwise.
2. ISODD: Similar to the ISLOGICAL function, it checks whether the given value is odd.
3. ISNUMBER Google Sheets: This function checks whether the given value is a number.
4. ISNONTEXT: It checks whether a value is not a text, like the other functions.
5. ISREF: It checks whether the given argument is a valid cell reference and returns TRUE if so.
6. ISNA: This formula checks if a supplied value is the #N/A error.
7. ISBLANK: It is used to check whether a referenced cell is blank. 8. ISERROR: It checks whether the given value is an error.
Given below are the uses of the ISLOGICAL function.
1. It is used in data Validation such as to check if the given input value in a cell is a logical value.
2. It is used to apply conditional formatting based on logical values in a range of cells.
3. We also use ISLOGICAL in the conditional part in conjunction with logical functions like IF, AND, or OR.
The ISLOGICAL function will not return TRUE as it normally does if the given value is “TRUE” or “FALSE” if it is a string. It is because only recognizes TRUE or FALSE logical values.
For instance, if C1 contains the string “TRUE”, =ISLOGICAL(C1) returns FALSE.
Download Template
This article must help understand ISLOGICAL in Google Sheets with its formulas and examples. You can download the template here to use it instantly.
Recommended Articles
Guide to What Is ISLOGICAL in Google Sheets. We learn its syntax & how to use it to find if a value is TRUE or FALSE with examples. You can learn more from the following articles.
Leave a Reply