ISLOGICAL function - The function returns True if the value is a logical value in Excel

ISLOGICAL function: The function returns True if that value is a logical value in Excel. Syntax: ISLOGICAL (value)

The following article introduces you to the ISFLOGICAL function - one of the functions in the information function group is very popular in Excel.

Picture 1 of ISLOGICAL function - The function returns True if the value is a logical value in Excel

Description: The function returns True if the value is a logical value in Excel.

Syntax: ISLOGICAL (value)

Inside:

- value: The value you want to test is a logical value or not, is a required parameter.

Attention:

- The function returns True if the value is logical and vice versa, the function returns False.

For example:

Is determining the value in value logical?

Picture 2 of ISLOGICAL function - The function returns True if the value is a logical value in Excel

- In the cell to calculate enter the formula : = ISLOGICAL (C6)

Picture 3 of ISLOGICAL function - The function returns True if the value is a logical value in Excel

- Press Enter -> return value is:

Picture 4 of ISLOGICAL function - The function returns True if the value is a logical value in Excel

- Because cell C6 is logical here, the function returns True.

- Similarly copying the formula for the remaining values ​​results:

Picture 5 of ISLOGICAL function - The function returns True if the value is a logical value in Excel

- Where the value is not a logical value -> the function returns a value of False

Picture 6 of ISLOGICAL function - The function returns True if the value is a logical value in Excel

Above are instructions and some specific examples when using ISLOGICAL function in Excel.

Good luck!

You've just finished reading the article "ISLOGICAL function - The function returns True if the value is a logical value in Excel" edited by the TipsMake team. You can save islogical-function-the-function-returns-true-if-the-value-is-a-logical-value-in-excel.pdf to your computer here to read later or print it out. We hope this article has provided you with many useful tech tips and tricks. You can search for similar articles on tips and guides. Thank you for reading and for following us regularly.

« PREV : ISNA function - The...
ISFORMULA function -... : NEXT »