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.

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

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?

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

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

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

- Press Enter -> return value is:

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

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

- Similarly copying the formula for the remaining values results:

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

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

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

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

Good luck!

Lesley Montoya

Update 19 May 2020

You should read it

May be interested

MAXA function - The function returns the largest value in a set of values including text and logical values in Excel
maxa function: the function returns the largest value in a set of values including text and logical values. syntax: maxa (value1, [value2], ...)
STDEV.S function - The function returns the standard deviation based on a sample in Excel
stdev.s function: the function returns the standard deviation based on a sample, ignoring logical values and text. standard deviation is a measure of the dispersion of values against the mean. support functions from excel 2010 onwards. syntax: stdev.s (number1, [number2], ...)
AVERAGEA function - The function returns the average of the arguments including numeric, text, and logical values in Excel
averagea function: the function returns the average of the arguments including numeric, text, and logical values. syntax: averagea (value1, [value2], ...)
ISREF function - The function returns True if the value is a valid reference value in Excel
isref function: the function returns true if that value is a valid reference value. application function to check if the value is a reference value or not. syntax: isref (value)
Logical functions (logical) in Excel
logical functions are used a lot during data processing in excel. the article summarizes the syntax and functions of functions in logical function groups in excel.
IFERROR function in Excel, formulas, and usage
the iferror function in excel corrects a formula error, returning a different value that replaces the error message in the normal way.
ISNUMBER function - The function returns True if the value is numeric in Excel
isnumber function: the function returns true if the value is numeric. use the function to check if the value is numeric or not. syntax: isnumber (value)
ISEVEN function - Function returns True value if the value is even in Excel
iseven function: the function returns true if the value is even in excel. syntax: iseven (value)
How to use the NORMDIST function in Excel - Function that returns the distribution in Excel
the normdist function returns a distribution with a specified mean and standard deviation. the normdist function has applications in statistics, including hypothesis testing.
ISNA function - The function returns True if the value is an # N / A error value in Excel
isna function: the function returns true if the value is an # n / a error value in excel. syntax: isna (value)