The following article introduces you to the ISFLOGICAL function - one of the functions in the information function group is very popular 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?
- In the cell to calculate enter the formula : = ISLOGICAL (C6)
- Press Enter -> return value is:
- Because cell C6 is logical here, the function returns True.
- Similarly copying the formula for the remaining values results:
- Where the value is not a logical value -> the function returns a value of False
Above are instructions and some specific examples when using ISLOGICAL function in Excel.
Good luck!