ISLOGICAL function - The function returns True if the value is a logical value in Excel
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!
You should read it
- How to use the IFS function in Excel 2016
- How to use the IF function in Excel
- AND function in Excel
- OR function in Excel, how to use the OR function, and examples
- ISODD function - The function returns True if the value is an odd number in Excel
- ISFORMULA function - The function returns True if that cell refers to a cell containing a formula in Excel
- STDEV.P function - The function returns the standard deviation based on the whole in Excel
- ISNONTEXT function - The function returns True if the value is not a text value in Excel
- ISTEXT function - Function returns True value if that value is text in Excel
- STDEV.S function - The function returns the standard deviation based on a sample in Excel
- IFERROR function in Excel, formulas, and usage
- MINA function - The function returns the smallest value in the given numbers including text and logical values in Excel
Maybe you are interested
AMD has surpassed Intel in brand value
SQL way to count NULL and NOT NULL values in a column
Comparing Odroid-N2+ and Raspberry Pi 4: Which option offers better value?
How to receive free gifts from IObit with a total value of nearly 150,000 USD
Write a program to find duplicate values in Python
Write a program to check duplicate values in Python