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.
Cet exercice fait partie du cours
Intermediate Google Sheets
Instructions
- In column
H, round the aphelion down to the nearest whole number. - In column
I, round the perihelion up to the next tenth.
Exercice interactif pratique
Passez de la théorie à la pratique avec l’un de nos exercices interactifs
Commencer l’exercice