Difference between revisions of "Documentation/How Tos/Calc: CEILING function"
From Apache OpenOffice Wiki
< Documentation | How Tos
(Initial content) |
m |
||
| Line 3: | Line 3: | ||
== CEILING == | == CEILING == | ||
Returns a number rounded up to a multiple of another number. | Returns a number rounded up to a multiple of another number. | ||
| − | |||
=== Syntax: === | === Syntax: === | ||
| Line 10: | Line 9: | ||
: If <tt>'''mode'''</tt> is zero or omitted, <tt>'''CEILING'''</tt> rounds up to the multiple above (greater than or equal to) <tt>'''number'''</tt>. If <tt>'''mode'''</tt> is non-zero, <tt>'''CEILING'''</tt> rounds up away from zero. This is only relevant with negative numbers. | : If <tt>'''mode'''</tt> is zero or omitted, <tt>'''CEILING'''</tt> rounds up to the multiple above (greater than or equal to) <tt>'''number'''</tt>. If <tt>'''mode'''</tt> is non-zero, <tt>'''CEILING'''</tt> rounds up away from zero. This is only relevant with negative numbers. | ||
| − | |||
: Use <tt>'''mode'''</tt><nowiki>=</nowiki><tt>'''1'''</tt> for compability if you have negative numbers and wish to export to MS Excel. In MS Excel this function only takes two arguments. | : Use <tt>'''mode'''</tt><nowiki>=</nowiki><tt>'''1'''</tt> for compability if you have negative numbers and wish to export to MS Excel. In MS Excel this function only takes two arguments. | ||
| − | |||
=== Example: === | === Example: === | ||
| Line 27: | Line 24: | ||
<tt>'''CEILING(-11; -2; 1)'''</tt> | <tt>'''CEILING(-11; -2; 1)'''</tt> | ||
: returns <tt>'''-12'''</tt>, because with <tt>'''mode'''</tt><nowiki>=</nowiki><tt>'''1'''</tt> the function rounds away from zero. | : returns <tt>'''-12'''</tt>, because with <tt>'''mode'''</tt><nowiki>=</nowiki><tt>'''1'''</tt> the function rounds away from zero. | ||
| − | |||
=== See also: === | === See also: === | ||
| Line 40: | Line 36: | ||
'''[[Documentation/How_Tos/Calc: ROUNDDOWN function|ROUNDDOWN]]''', | '''[[Documentation/How_Tos/Calc: ROUNDDOWN function|ROUNDDOWN]]''', | ||
'''[[Documentation/How_Tos/Calc: ROUNDUP function|ROUNDUP]]''' | '''[[Documentation/How_Tos/Calc: ROUNDUP function|ROUNDUP]]''' | ||
| − | |||
'''[[Documentation/How_Tos/Calc: Mathematical functions|Mathematical functions]]''' | '''[[Documentation/How_Tos/Calc: Mathematical functions|Mathematical functions]]''' | ||
Revision as of 06:32, 2 March 2008
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.
