Excel ISLOGICAL Function

What is ISLOGICAL function in Excel?

The ISLOGICAL function is one of the Information functions of Excel.

It Checks whether a value is a logical value, and returns TRUE or FALSE.

We can find this function in Information of insert function Tab.

How to use ISLOGICAL function in excel

  1. Click on an empty cell (like F5).
empty cell in excel

2. Click on the fx icon (or press shift+F3).

fx icon in excel

3. In the insert function tab you will see all functions.

insert function tab in excel

4. Select Information category.

5. Select ISLOGICAL function

6. Then select ok.

excel ISLOGICAL function

7. In the function arguments Tab you will see ISLOGICAL function.

8. Value is the value you want to test. Value can refer to a cell, a formula, or a name that refers to a cell, formula, or value.

9. You will see the results in the formula result section.

How to use ISLOGICAL function in excel

Examples of ISLOGICAL function in Excel

Examples of ISLOGICAL function in Excel

ISLOGICAL related functions

  • Use ISFORMULA function to check whether a reference is to a cell containing a formula.
  • Use ISNA function to check whether a value is=N/A and returns TRUE or FALSE.
  • Use ISREF function to check whether a value is a reference, and returns TRUE or FALSE.
  • Use ISNUMBER function to check whether a value is a number, and return TRUE or FALSE.

Leave a Reply

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