CEILING() Rounds up to the next integer ------------------------------------------------------------------------------ Syntax CEILING(<nValue>) --> nLargerInteger Argument <nValue> Designates the number for which the next-largest integer is determined. Returns CEILING() returns the next-largest integer to the one that is passed as a parameter. Description CEILING() returns the next-largest integer to the one passed as a parameter. This applies to positive and negative numbers. Example Show the next-largest integer (including positive and negative numbers): ? CEILING(1.9) // Result: 2 ? CEILING(1.1) // Result: 2 ? CEILING(0.9) // Result: 1 ? CEILING(-0.1) // Result: 0 ? CEILING(-0.9) // Result: 0 ? CEILING(-1.1) // Result:-1
See Also: FLOOR()