LoslegenKostenlos loslegen

From floor to ceiling

Sometimes you always want to round a value down (towards negative infinity), or always round upwards (towards infinity). You can do this using

Both functions take a second argument that specifies the multiple to round to. For example, FLOOR(A1, 0.01) rounds the number in cell A1 down to the next lowest hundredth. If this argument is omitted, it rounds down to the nearest whole number.

Diese Übung ist Teil des Kurses

Intermediate Google Sheets

Kurs anzeigen

Anleitung zur Übung

  • In column H, round the aphelion down to the nearest whole number.
  • In column I, round the perihelion up to the next tenth.

Interaktive Übung

In dieser interaktiven Übung kannst du die Theorie in die Praxis umsetzen.

Übung starten