Number Rounding

Search…

Number Rounding

Specify the amount of decimal places to round an answer to. This will override the line's default precision settings.
1/3 to 2 dp                                    | 0.33
π to 5 digits                                  | 3.14159
​
5.5 rounded                                    | 6
5.5 rounded down                               | 5
5.5 rounded up                                 | 6
​
37 to nearest 10                               | 40
$490 rounded to nearest hundred                | $500
2,100 to nearest thousand                      | 2,000
​
Or use one of the following functions:
Function
Name
Behaviour
round()
Integer round
Rounds a number to the nearest integer
ceil()
Ceiling
Rounds a number up to the nearest whole number
floor()
Floor
Rounds a number down to the nearest whole number

Functions - Previous

General

Next - Functions

Dates & Timestamps

Last modified 20d ago

Copy link