What is EXCEL ISLOGICAL FUNCTION
The Excel ISLOGICAL Function is listed under Microsoft Excel's Information Functions category. It returns TRUE if the value supplied (or the value in the cell referred) is a logical value. WIth a logical value, means TRUE or FALSE. That means if the value is TRUE or FALSE it returns a TRUE else FALSE.
How to use it
To learn how to use the ISLOGICAL function in Excel, you need to understand its syntax and arguments:
- value: The value that you want to evaluate.
- If cell reference is not a valid reference it will return #VALUE!.
To master the ISLOGICAL function we need to try it out in an example, so make sure to check out the below one:
Below we have used different arguments:
- In the FIRST cell, we have entered a simple TRUE value and in the SECOND cell, we have used TRUE function. It has returned TRUE for both of the values as both of the values are logical values.
- In the THIRD and FOURTH cells, we have used FALSE value and FALSE function respectively and it has returned the same result for both of the values.
- In FIFTH and SIXTH, as logical values TRUE and FALSE have numeric values 1 and 0 as well but ISLOGICAL will not treat these number logical values.
- In SEVENTH and EIGHTH, we used text values to evaluate and it returns FALSE.
- In the NINTH, we have used blank cell it returns FALSE and in the TENTH, if value contains an error it will return a #N/A value.
This tutorial is the part of our Excel Functions with Examples (Function Guide) and below are some of the related functions:
- EXCEL CELL Function
- EXCEL ERROR.TYPE Function
- EXCEL INFO Function
- EXCEL ISBLANK Function
- EXCEL ISERR Function
- EXCEL ISERROR Function
- EXCEL ISEVEN Function
- EXCEL ISFORMULA Function
- EXCEL ISNA Function
- EXCEL ISNONTEXT Function
- EXCEL ISNUMBER Function
- EXCEL ISODD Function
- EXCEL ISREF Function
- EXCEL ISTEXT Function
- EXCEL N Function
- EXCEL NA Function
- EXCEL SHEET Function
- EXCEL SHEETS Function
- EXCEL TYPE Function
About the Author
Puneet is using Excel since his college days. He helped thousands of people to understand the power of the spreadsheets and learn Microsoft Excel. You can ﬁnd him online, tweeting about Excel, on a running track, or sometimes hiking up a mountain.