Basic FunctionsIntermediate

EVEN and ODD Functions

Round numbers to the nearest even or odd integer.

Task:

You are working on a project that requires rounding numbers to the nearest even or odd integer for specific calculations. Round the numbers to the nearest even integer in column B and the nearest odd integer in column C to meet these requirements.

Interactive Spreadsheet

Read about EVEN, ODD

Hints

+5 XPno-hints bonus

Solve it on your own to keep the bonus. Each hint gets one step closer to the formula.

Variations of EVEN, ODD

0/3

The same formula in the other shapes it takes at work.

  1. EVEN and ODD Functions

    Round numbers to the nearest even or odd integer.

    CoreIntermediate
  2. EVEN for things sold in pairs

    Round any quantity up to the next even number.

    Beginner
  3. ODD when a layout needs a middle

    An odd count always has a centre seat, column or tile.

    Intermediate

The data in this exercise

This is the grid you start with. Cell references in the task — B6, C2 — point at the row numbers and column letters below.

5 rows × 3 columns8 cells you fill in
ABC
1NumberEvenOdd
27.3
312.8
45.1
518.9

Functions used here

What this exercise teachesMay contain the answer

EVEN and ODD functions are useful for specific rounding requirements where results must be even or odd integers.