# ISODD function in Excel

> ISODD returns TRUE when a number is odd.

Source: https://spreadsheetpractice.com/functions/isodd · 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:** ISODD returns TRUE when a number is odd.
- **Syntax:** `=ISODD(number)`
- **Most common use:** `=IF(ISODD(B2),"Left side","Right side")` returns Left side (Seat 11 is odd, so it's on the left)
- **Available in:** Every current version
- **Category:** [Information functions](https://spreadsheetpractice.com/functions/category/info)
- **Returns:** TRUE if the number is odd, FALSE if it is even. #VALUE! for text.
- **Google Sheets:** Available in Google Sheets with the same argument.

## What it does

ISODD returns TRUE when a number is odd. Use it to split items into two groups, alternate seating or batches, or shade odd rows. Negative numbers work, and decimals are dropped first, so 7.5 counts as 7.

## Syntax

`=ISODD(number)`

| Argument | Required? | What it is |
|---|---|---|
| `number` | Required | The number to test. Decimals are truncated, so 7.5 counts as 7. |

## Examples

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

| Cell | Formula | Result | What it shows |
|---|---|---|---|
| D2 | `=IF(ISODD(B2),"Left side","Right side")` | Left side | Seat 11 is odd, so it's on the left |
| E2 | `=SUMPRODUCT(--(MOD(B2:B6,2)=1))` | 3 | ISODD takes one value at a time, so count a range with MOD |
| F2 | `=ISODD(-3)` | TRUE | Negative numbers work too |

### The sample sheet

Every formula above runs on this data:

|  | A | B | C | D | E | F |
|---|---|---|---|---|---|---|
| 1 | Ticket | Seat |  | Row 2 side | Odd seats | Is -3 odd? |
| 2 | T-881 | 11 |  | Left side | 3 | TRUE |
| 3 | T-882 | 14 |  |  |  |  |
| 4 | T-883 | 23 |  |  |  |  |
| 5 | T-884 | 30 |  |  |  |  |
| 6 | T-885 | 37 |  |  |  |  |

## Common mistakes

| What you see | Why, and how to fix it |
|---|---|
| #VALUE! | The value is text, such as "Seat 11". Extract the number first, for example with VALUE(MID(A2,6,3)). |
| #VALUE! for a whole range | ISODD tests one value at a time. Count odd numbers in a range with =SUMPRODUCT(--(MOD(B2:B6,2)=1)). |
| Decimals give surprising results | 7.5 counts as 7, which is odd, because the decimal part is dropped. Round first if that matters. |

## Tips

- Highlight odd rows with the conditional formatting rule =ISODD(ROW()).

## Related functions

- [ISEVEN](https://spreadsheetpractice.com/functions/iseven): ISEVEN returns TRUE when a number is even.
- [MOD](https://spreadsheetpractice.com/functions/mod): MOD returns the remainder after dividing one number by another.
- [ROW](https://spreadsheetpractice.com/functions/row): ROW returns the row number of a cell: ROW(C7) is 7, and ROW() with nothing inside returns the row of the cell the formula sits in.

## Questions

### How do I check if a number is odd in Excel?

=ISODD(A2) returns TRUE for odd numbers. =MOD(A2,2)=1 does the same for whole numbers.

### Does ISODD work with negative numbers?

Yes. =ISODD(-3) is TRUE and =ISODD(-4) is FALSE.

## Practice

A graded ISODD exercise ("Two teams") is on [the ISODD page](https://spreadsheetpractice.com/functions/isodd). 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.
