Truncation and Rounding Functions

floor(z) Returns the greatest integer ≤ z.
Floor(z, y) Returns the greatest multiple of y ≤ z.

ceil(z) Returns the smallest integer ≥ z.
Ceil(z, y) Returns the smallest multiple of y ≥ z.

round(z, [n]) Returns z rounded to n decimal places. If n is omitted, returns z rounded to the nearest integer (n is assumed to be zero). If n < 0, returns z rounded to n places to the left of the decimal point. If the (n + 1)th decimal place is less than 5, the number is rounded down, otherwise, it is rounded up.
Round(z, y) Returns round(z / y) · y, which rounds z to the closest multiple of y. Note that round(z, 1) = Round(z, 0.1).

trunc(z) Returns the integer part of z by removing the fractional part.
Trunc(z, y) Returns trunc(z / y) · y.

Arguments:

Notes:

QuickSheet