CEILING


Returns a number rounded up to a multiple of another number.

Syntax:

CEILING(number, mult, mode)
number is the number that is to be rounded up to a multiple of mult.If mode is zero or omitted, CEILING rounds up to the multiple above (greater than or equal to) number. If mode is non-zero, CEILING rounds up away from zero. This is only relevant with negative numbers. Use mode=1 for compability if you have negative numbers and wish to export to MS Excel. In MS Excel this function only takes two arguments.

Example:

CEILING(4, 3)
returns 6, because 2*3 = 6 is the next multiple of 3 above 4.
CEILING(6, 3)
returns 6.
CEILING(-11, -2)
returns -10, rounding to the multiple above.
CEILING(-11, -2, 1)
returns -12, because with mode=1 the function rounds away from zero.






 
Created with Zapof