Excel - ISLOGICAL Function
ISLOGICAL Function
The Excel ISLOGICAL function scrutinizes the cell content and retrieves the boolean value once the data is validated. If the cell content or computation of the formula contains either YES/NO or TRUE/FALSE values, then the ISLOGICAL retrieves TRUE and vice versa. This versatile function integrates with dynamic arrays, complex formulas, and condition statements.
No matter the type of data in the cell range, such as numeric values, text, date, time, or error, this function always returns FALSE for non-logical values.
Compatibility
This advanced Excel function is compatible with the following versions of MS Excel −
- Excel for Microsoft 365
- Excel for Microsoft 365 for Mac
- Excel for the web
- Excel 2024
- Excel 2024 for Mac
- Excel 2021
- Excel 2021 for Mac
- Excel 2019
- Excel 2016
- Excel Web App
- Excel 2013
- Excel 2009
- Excel 2007
Syntax
The syntax of the ISLOGICAL function is as follows −
=ISLOGICAL(value)
Arguments
You can use the following arguments with the ISLOGICAL function −
| Argument | Description | Required/Optional |
|---|---|---|
| Value | Value or expression. | Required |
Points to Remember
- If the Value argument specifies the circular reference, the ISLOGICAL function retrieves the 0.
- If you specify the YES/NO in the dynamic array like =ISLOGICAL({YES, NO, 67, "TRUE"}), then the function returns the #NAME error.
How to use the ISLOGICAL Function in Excel?
Below are steps are written below to get to know about the ISODD function:
- Open a new Excel worksheet in a workbook.
- Double-click on the targeted cell and write the = sign, then type ISLOGICAL(array/cell reference/expression to be evaluated ). For instance, =ISLOGICAL(A2:A12).
- Press the Enter tab to obtain the resulting value.
Examples of ISLOGICAL Function
Practice the following examples to learn the use of the ISLOGICAL function in Excel.
Example 1: How to use the ISLOGICAL Function in Excel?
Solution
Step 1 − Assume the sample dataset, with input data specified in the cell range A2:A6. When implied between two numbers, the logical operator gives a result as a logical value.
Step 2 − After that, you can select the cell range B2:B6 and write the formula =ISLOGICAL(A2) in the formula bar.
Then, press the "Ctrl + Enter" tab to get the computed result. Once you press these shortcut keys, the result is automatically displayed in the B2:B6 range.
Example 2
Suppose you wish to find the logical values in the dynamic array. The ISLOGICAL function is the best method for identifying Boolean values.
Solution
You may enter the formula =ISLOGICAL( {12,"Yes",TRUE,FALSE,23,"t1"}) in the B2 cell
After pressing the Enter tab, the resulting value is automatically displayed horizontally.
The FALSE is populated in this screenshot if the array element is a number or text.
Example 3: Using FILTER and ISLOGICAL function
You can filter or sort the Boolean dataset using Excel's FILTER and ISLOGICAL functions. Select the cell C2 and write the formula =FILTER(B2:B8,ISLOGICAL(B2:B8)).
After that, hit the Enter tab. Therefore, the array was filtered, and only logical values were extracted from the cell range B2:B8.