IsLogical function in Excel

What is a Logical Value?

TURE or FALSE are treated as logical values in Excel.

Use

Tests whether a value is a logical or not.

Description

Returns TRUE if the tested value is logical otherwise FALSE for other values.

Syntax

=ISLOGICAL (value)

Where, (value) is a reference to a cell in which you want to test ISLOGICAL function.

Example

Formulas:

Results:

Counting logical values in a column

Use COUNTIF function in Excel to count logical values like:

1- To count a number of cells that contain TRUE.

2- To count a number of cells that contain FALSE.

Copyright © 2016 - 2018 Explainry.com | All Rights Reserved