ROUNDUP


Rounds a number up, away from zero, to a certain precision.

Syntax:

ROUNDUP(number, places)
returns number rounded up (away from zero) to places decimal places. If places is omitted or zero, the function rounds up to an integer. If places is negative, the function rounds up to the next 10, 100, 1000, etc. This function rounds away from zero.

Example:

ROUNDUP(1.1111, 2)
returns 1.12
ROUNDUP(1.2345, 1)
returns 1.3
ROUNDUP(45.67, 0)
returns 46
ROUNDUP(-45.67)
returns -46
ROUNDUP(987.65, -2)
returns 1000






 
Created with Zapof