January 21, 2022

How to use ISLOGICAL Function in Excel

The Excel ISLOGICAL function returns TRUE when a cell contains the logical values TRUE or FALSE, and returns FALSE for cells that contain any other value, including empty cells.

Syntax:= ISLOGICAL (value)

The ISLOGICAL function syntax has the following arguments:

• Value (required argument) – This is the value we wish to test as logical or not. Value can be a blank (empty cell), error, logical, text, number, or reference value, or a name referring to any of these, that we want to test.

Example: Let’s look at some Excel ISLOGICAL function examples and explore how to use the ISLOGICAL function as a worksheet function in Microsoft Excel: Syntax:  =ISLOGICAL(A2)

Result: Based on the Excel spreadsheet above, the following ISLOGICAL examples would return:

Syntax: =ISLOGICAL(A3)
Result: FALSE

Syntax: =ISLOGICAL(A4)
Result: FALSE

Syntax: =ISLOGICAL(A5)
Result:TRUE

Syntax: =ISLOGICAL(A6)
Result: TRUE

Syntax: =ISLOGICAL(A7)
Result: FALSE

Syntax: =ISLOGICAL(A8)
Result: FALSE

Syntax: =ISLOGICAL(A9)
Result: FALSE

Syntax: =ISLOGICAL(A10)
Result: FALSE

Syntax: =ISLOGICAL(A11)
Result: FALSE

Note:

Use the ISLOGICAL function to check if a value is logical. ISLOGICAL will return TRUE when a value is TRUE or FALSE.

For example, =ISERROR(A1) will return TRUE if A1 contains either TRUE or FALSE.

Note that 1 and 0 (zero) are not evaluated as TRUE and FALSE. However, you can use the AND function to evaluate 1 and 0 and TRUE and FALSE.

Normally, value is supplied as a cell address.

ISLOGICAL is part of a group of functions called the IS functions, which are often used to test the result of formulas for errors.

READ:  How to use SHEETS Function in Excel 