LoslegenKostenlos starten

Round and round

Often, numbers are easier to read if you limit how precisely they are written. For example, 75 is easier to read than 74.9729526456456.

ROUND() lets you round numbers to a specified number of decimal places.

  • ROUND(A1) rounds the number in cell A1 to the nearest whole number.
  • ROUND(A1, 3) rounds it to three decimal places - or, in other words, to the nearest thousandth.
  • ROUND(A1, -3) rounds it to the nearest thousand.

Diese Übung ist Teil des Kurses

<Kurs>Google Sheets: Fortgeschrittene Funktionen</Kurs>
Kurs ansehen

Übungsanweisungen

  • In column H, round the aphelion to the nearest whole number.
  • In column I, round the perihelion to one decimal place (to the nearest tenth)
  • In column J, round the upper bound of the size to the nearest hundred.

Interaktive praktische Übung

Verwandle Theorie mit einer unserer interaktiven Übungen in die Praxis

Übung starten