Buzz
This article introduces you to the ISFLOGICAL function - one of the functions in the information group widely used in Excel.
Description: Returns True if the value is a logical value in Excel.
Syntax: ISLOGICAL(value)
Regarding:
- value: The value to check whether it is a logical value or not, is a required parameter.
Note:
- The function returns True if the value is a logical value and conversely, the function returns False.
Example:
Determine whether the values in value are logical values or not?
- In the cell to be calculated, enter the formula: =ISLOGICAL(C6)
- Press Enter -> the returned value is:
- Here, the value of cell C6 is logical so the function returns True.
- Similarly, copying the formula for the remaining values yields:
- In case value is not a logical value -> the function returns False
Above is the guide and some specific examples of using the ISLOGICAL function in Excel.
Wishing you all success!
