Revision as of 02:52, 13 March 2017

CEILING(number, significance)

CEILING() rounds the number up, away from zero, to its nearest multiple of significance.

For Example,

CEILING(3.5, 2) returns 4.

CEILING(-4.6, -2) returns -6.

Calci returns an NaN error message if the argument is nonnumeric.
Calci returns an #ERROR message if 'number' and 'significance' have different signs.
If the number is an exact multiple of significance, rounding will not be done. Calci will display the same number as output.
If significance value is not mentioned, Calci assumes it to be 1.
This function can also be used for array of numbers in form of equation as-

 a) CEILING(3.33..6.33,0.1) where x varies from 3.33 to 6.33 and displays output to multiples of 0.1. Displays 3.4,4.4,5.4,6.4 as output.

 b) 2.5..4.5|CEILING(x+2,2)| where x varies from 2.5 to 4.5 , adds value 2 and displays output to multiples of 2. Displays 6,6,8 as output.

@@ Line 70: / Line 70: @@
 *[http://en.wikipedia.org/wiki/Rounding#Tie-breaking Rounding]
 *[http://http://en.wikipedia.org/wiki/Floor_and_ceiling_functions CEILING Function]
+*[[Z_API_Functions | List of Main Z Functions]]
+*[[ Z3 |   Z3 home ]]