Notice: This page requires JavaScript to function properly.
Please enable JavaScript in your browser settings or update your browser.
Oppiskele Rounding Functions | Basic Functions
Google Spreadsheets Tutorial

bookRounding Functions

Rounding Up

The ROUNDUP function always rounds a value up, regardless of the number after the rounding place. This is useful in situations where a higher value is required, even if the fractional part is less than 5. For example, when calculating material stock or time estimates to avoid shortages.

Rounding Down

The ROUNDDOWN function always rounds a number down, regardless of the digits after the rounding place. This is useful in scenarios where exceeding a limit must be avoided, such as budgeting or planning.

Task: Understanding ROUND, ROUNDUP, and ROUNDDOWN

You have the following values in your spreadsheet:

AFormulaExpected Result
23.678=ROUND(A1, 1)?
23.678=ROUNDUP(A1, 1)?
23.678=ROUNDDOWN(A1, 1)?
question mark

Which of the following answer choices correctly fills in the expected results for each formula?

Select the correct answer

Oliko kaikki selvää?

Miten voimme parantaa sitä?

Kiitos palautteestasi!

Osio 6. Luku 4

Kysy tekoälyä

expand

Kysy tekoälyä

ChatGPT

Kysy mitä tahansa tai kokeile jotakin ehdotetuista kysymyksistä aloittaaksesi keskustelumme

Awesome!

Completion rate improved to 1.45

bookRounding Functions

Pyyhkäise näyttääksesi valikon

Rounding Up

The ROUNDUP function always rounds a value up, regardless of the number after the rounding place. This is useful in situations where a higher value is required, even if the fractional part is less than 5. For example, when calculating material stock or time estimates to avoid shortages.

Rounding Down

The ROUNDDOWN function always rounds a number down, regardless of the digits after the rounding place. This is useful in scenarios where exceeding a limit must be avoided, such as budgeting or planning.

Task: Understanding ROUND, ROUNDUP, and ROUNDDOWN

You have the following values in your spreadsheet:

AFormulaExpected Result
23.678=ROUND(A1, 1)?
23.678=ROUNDUP(A1, 1)?
23.678=ROUNDDOWN(A1, 1)?
question mark

Which of the following answer choices correctly fills in the expected results for each formula?

Select the correct answer

Oliko kaikki selvää?

Miten voimme parantaa sitä?

Kiitos palautteestasi!

Osio 6. Luku 4
some-alt