ISLOGICAL

Formulas / ISLOGICAL
Test if a value is logical.
FALSE
  • value - required argument that can be a blank cell, error, logical value, text, number, or reference value

Examples

    This example uses the ISLOGICAL function to evaluate the logical value TRUE. The ISLOGICAL function takes in one argument, in this case the logical value TRUE, and returns the logical value TRUE. This is because TRUE is a logical value and ISLOGICAL will return TRUE as a result.

    This example uses the ISLOGICAL function to evaluate the logical value FALSE. The ISLOGICAL function takes in one argument, in this case the logical value FALSE, and returns the logical value TRUE. This is because FALSE is a logical value and ISLOGICAL will return TRUE as a result.

    This example uses the ISLOGICAL function to evaluate a cell in a worksheet. The ISLOGICAL function takes in one argument, in this case the cell A2, and returns the logical value TRUE if the cell contains a logical value, or FALSE if the cell does not contain a logical value. For example, if A2 contains the logical value TRUE, then ISLOGICAL will return TRUE as a result.

    This example uses the ISLOGICAL function to evaluate a text string. The ISLOGICAL function takes in one argument, in this case the text string "TRUE", and returns the logical value FALSE. This is because the text string "TRUE" is not a logical value and ISLOGICAL will return FALSE as a result.

Summary

The ISLOGICAL function returns TRUE if the argument is either TRUE or FALSE, and FALSE for any other value. It accepts one argument, either a cell reference, formula or hardcoded value.

  • The ISLOGICAL function returns TRUE if a cell contains a logical value of TRUE or FALSE and FALSE for cells that do not contain logical values.
  • The ISLOGICAL function takes one argument, which can be a cell reference, a formula, or a hardcoded value.
  • When the argument is a logical value, the function returns TRUE; when the argument is not a logical value, the function returns FALSE.


Frequently Asked Questions

What is the ISLOGICAL Function?
The ISLOGICAL function is a Sourcetable information function that tests the value or expression provided and returns a logical value. It is part of the IS function and is useful for checking data or analysis for errors.
How can the ISLOGICAL Function be used?
The ISLOGICAL function can be used to test the result of formulas and check data or analysis for errors. It returns a true or false value to indicate whether the expression being tested is a logical value.
What are the Benefits of using the ISLOGICAL Function?
  • Helps to quickly identify errors in data or analysis
  • Provides a logical value to indicate if an expression is a logical value
  • Can be used to test the result of formulas
Are there any Limitations to using the ISLOGICAL Function?
There are no specific limitations to using the ISLOGICAL function, however, it can be difficult to troubleshoot errors when the function returns a false value.

Related Functions

Sourcetable Logo

Work smarter

Al is here to help. Leverage the latest models to
analyze spreadsheets, enrich data, and create reports.

Drop CSV