Skip to content

Lessons in your language are coming soon. Formulas already work in your Excel language.

Lesson 7/7

ROUND, CEILING, FLOOR, EVEN, ODD

Exercise 1 of 6

In B2, round the price to 2 decimals.

About this lesson

ROUND rounds to a number of decimals, CEILING and FLOOR round up or down to a multiple, such as the next 5, and EVEN and ODD round up to the next even or odd whole number.

In this lesson

  1. In B2, round the price to 2 decimals.
  2. In B2, round the number of visitors to the nearest hundred.
  3. Prices end in 0 or 5 cents. In B2, round the price up to the next 0.05.
  4. Calls are billed in whole quarter hours, rounded down. In B2, round the minutes down to a multiple of 15.
  5. Guests sit at tables for two, so the number of seats must be even. In B2, round the 23 guests up to an even number.
  6. A panel of judges needs an odd number so a vote can't tie. In B2, round the 6 volunteers up to an odd number.

Use the arrow keys to move between cells; each cell is read out as you go. Type a formula and press Enter. The sheet is also available as a table below.

fx

Type in B2 and press Enter to check.