Basic Functions
Intermediate

ODD when a layout needs a middle

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

Task:

Each display wall needs an odd number of panels so one sits dead centre. In C2:C6 give the number of panels to fit: the panels that would fill the wall, rounded up to an odd 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
1WallPanels to fillPanels to fit
2Lobby6
3Atrium9
4Corridor3.2
5Showroom10.5
6Reception1
What this exercise teachesMay contain the answer

ODD rounds up to the next odd integer, so 3.2 skips 4 and lands on 5 — a slightly wider panel run, but a symmetrical one. Like EVEN, it never rounds down, so the wall is always covered.