12 April 2014: The OpenOffice Wiki is not, and never was, affected by the heartbleed bug. Users' passwords are safe and wiki users do not need take any actions.

Documentation/How Tos/Calc: CEILING function

From Apache OpenOffice Wiki
Jump to: navigation, search


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.

See Also

Retrieved from "https://wiki.openoffice.org/w/index.php?title=Documentation/How_Tos/Calc:_CEILING_function&oldid=225718"
Views
Personal tools
Navigation
Print/export
Tools