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

• FLOOR(), which rounds down, and
• CEILING(), which round up.

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.