Basic FunctionsBeginner

ROUND Function

Round numbers to specific decimal places.

Task:

You are preparing a financial report and need to format the numbers to two decimal places for clarity. Round the calculated values in column B to 2 decimal places in column C to ensure the report is clean and professional.

Interactive Spreadsheet

Read about ROUND

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 ROUND

0/4

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

  1. ROUND Function

    Round numbers to specific decimal places.

    CoreBeginner
  2. ROUND to the nearest thousand

    A negative number of digits rounds to the left of the decimal point.

    Beginner
  3. ROUNDUP and ROUNDDOWN: rounding in one direction

    When the rule is "always up" or "always down", ROUND is the wrong tool.

    Intermediate
  4. ROUND inside a calculation

    Round each line where it is calculated, so the invoice adds up to the penny.

    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 columns4 cells you fill in
ABC
1CalculationResultRounded
2Division10.6666667
3Multiplication15.8333333
4Percentage33.3333333
5Average87.142857

Functions used here

What this exercise teachesMay contain the answer

The ROUND function helps format numbers to a specific number of decimal places, which is useful for presentation and consistency.