The ISLOGICAL function

The ISLOGICAL function is an information function which will return either TRUE or FALSE if the selected cell or values evaluate to a logical TRUE/FALSE result. The numbers one and zero are not considered to be logical outputs in this function.

This is the format of the ISLOGICAL function:

=ISLOGICAL(REFERENCE OR FORMULA)

Here is an example of the ISLOGICAL function:

=ISLOGICAL(“John”) = FALSE

ISLOGICAL returning TRUE when evaluating a cell whose contents contain a TRUE/FALSE value

This function is valuable when multiple response types are expected within a field, and they can vary between logical and variable types. Applying this logic allows for error handling before the errors even occur.

An example of a functional implementation of this would be if you have a form whose responses are TRUE, FALSE, or allowing the individual to enter their own response. Both TRUE and FALSE are logical outputs while the third is not. ISLOGICAL will allow us to create personalized responses based on these results.

=IF(ISLOGICAL(C3), “Thank you for your response”, “Please note that processing times can increase with custom requests”)