Basic Functions
Beginner

EVEN for things sold in pairs

Round any quantity up to the next even number.

Task:

Dining chairs only ship in pairs. In C2:C6 give the number of chairs to order for each request — the request rounded up to an even number.

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.

    Core
    Intermediate
  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.

6 rows × 3 columns5 cells you fill in
ABC
1CustomerChairs wantedChairs to order
2Cafe Uno7
3Bistro Dos12
4Tre Tavoli1
5Four Seasons Deli15
6Cinque20
What this exercise teachesMay contain the answer

EVEN always rounds away from zero, so 7 becomes 8 and 1 becomes 2 — never down to 6 or 0, which would leave a customer short. That one-direction behaviour is what makes it right for pack sizes of two.