ExcelFlux

ISLOGICAL function

TRUE if the value is a logical value.

Information

Where can you use it?

Workbook and data quality owners. Use functions that inspect cell type, errors or the calculation environment when validating a report.

Scenario in the workbook

Distinguish logical flags from the number one.

A worked example from the workbook

RowA
6Input
7TRUE
8FALSE
91
Record 1
=ISLOGICAL(A7)

Expected resultTRUE

See the inputs and instructions for all 3 examples

Copyable formulas

English Excel · en-US
=ISLOGICAL(TRUE)
Turkish Excel · tr-TR
=EMANTIKSALSA(DOĞRU)

Expected result

TRUE

Worked examples

Distinguish logical flags from the number one.

Open the English sheet. Inputs begin at A6. F7:F9 show the live results and G7:G9 show the original results for comparison.

Row A
6 Input
7 TRUE
8 FALSE
9 1
Case Formula Expected result
Record 1 =ISLOGICAL(A7) TRUE
Record 2 =ISLOGICAL(A8) TRUE
Record 3 =ISLOGICAL(A9) FALSE
Microsoft Excel reference