# ISLOGICAL function in Excel

> ISLOGICAL returns TRUE when a value is one of the logical values, TRUE or FALSE.

Source: https://spreadsheetpractice.com/functions/islogical · Updated October 28, 2026 · Formulas and results on this page were run by the Spreadsheet Practice formula engine on November 20, 2026

## Quick answer

- **What it does:** ISLOGICAL returns TRUE when a value is one of the logical values, TRUE or FALSE.
- **Syntax:** `=ISLOGICAL(value)`
- **Most common use:** `=SUMPRODUCT(--ISLOGICAL(B2:B6))` returns 3 (Three cells hold real TRUE or FALSE values)
- **Available in:** Every current version
- **Category:** [Information functions](https://spreadsheetpractice.com/functions/category/info)
- **Returns:** TRUE if the value is TRUE or FALSE. FALSE for everything else, including the text "TRUE".
- **Google Sheets:** Available in Google Sheets with the same argument.

## What it does

ISLOGICAL returns TRUE when a value is one of the logical values, TRUE or FALSE. Checkbox cells and comparisons produce them; imports often produce the text "TRUE" instead, which looks the same but behaves differently in counts and IF tests. ISLOGICAL tells the two apart.

## Syntax

`=ISLOGICAL(value)`

| Argument | Required? | What it is |
|---|---|---|
| `value` | Required | The value or cell to test. |

## Examples

Each result was calculated by running the formula on the sample sheet.

| Cell | Formula | Result | What it shows |
|---|---|---|---|
| D2 | `=SUMPRODUCT(--ISLOGICAL(B2:B6))` | 3 | Three cells hold real TRUE or FALSE values |
| E2 | `=IF(ISLOGICAL(B6),"OK","Not a checkbox value")` | Not a checkbox value | B6 shows TRUE, but it was typed in as text |
| F2 | `=SUMPRODUCT(--(B2:B6=TRUE))` | 2 | Tasks done: the text "TRUE" doesn't match a real TRUE |

### The sample sheet

Every formula above runs on this data:

|  | A | B | C | D | E | F |
|---|---|---|---|---|---|---|
| 1 | Task | Done |  | Real TRUE/FALSE values | Row 6 check | Tasks done |
| 2 | Invoices | TRUE |  | 3 | Not a checkbox value | 2 |
| 3 | Payroll | FALSE |  |  |  |  |
| 4 | Review | yes |  |  |  |  |
| 5 | Backup | TRUE |  |  |  |  |
| 6 | Audit | TRUE |  |  |  |  |

## Common mistakes

| What you see | Why, and how to fix it |
|---|---|
| FALSE for a cell that shows TRUE | The cell holds the text "TRUE", often from an import. Convert the column with =UPPER(B2)="TRUE", which returns a real TRUE or FALSE. |
| 1 and 0 aren't logical values | Some systems export yes and no as 1 and 0. ISLOGICAL is FALSE for them; =B2=1 turns them into real TRUE and FALSE values. |

## Tips

- A comparison is already logical: =ISLOGICAL(A2>10) is always TRUE, whatever A2 holds.

## Related functions

- [ISTEXT](https://spreadsheetpractice.com/functions/istext): ISTEXT returns TRUE when a value is text, including numbers that were stored as text and the empty text "" that some formulas return.
- [ISNUMBER](https://spreadsheetpractice.com/functions/isnumber): ISNUMBER returns TRUE when a value is a real number, which includes dates and times.
- [IF](https://spreadsheetpractice.com/functions/if): IF checks a condition and returns one value when it is true and another when it is false.

## Questions

### What is a logical value in Excel?

TRUE or FALSE. Comparisons like A2>10 return them, and checkbox cells store them.

### How do I count TRUE values in Excel?

=COUNTIF(B2:B50,TRUE) counts cells holding TRUE. To check that every value really is logical first, use =SUMPRODUCT(--ISLOGICAL(B2:B50)).

## Practice

A graded ISLOGICAL exercise ("Count real checkboxes") is on [the ISLOGICAL page](https://spreadsheetpractice.com/functions/islogical). It is checked instantly, then re-checked on changed data.

---

Spreadsheet Practice (https://spreadsheetpractice.com) teaches spreadsheet formulas by practice: every exercise is graded in a live grid and re-checked on changed data.
