| Line 1: |
Line 1: |
| − | <div id="16SpaceContent" align="left"><div class="ZEditBox" align="justify">
| + | =CEILING(number, significance)= |
| | | | |
| − | Syntax
| + | *Where 'number' is the numeric value to round and |
| | + | *'significance' is the multiple to round the number. |
| | | | |
| − | </div></div>
| + | CEILING() rounds the number down towards zero, to its nearest multiple of significance. |
| − | ----
| |
| − | <div id="4SpaceContent" align="left"><div class="ZEditBox" align="justify">
| |
| | | | |
| − | Remarks
| + | == Description == |
| | | | |
| − | </div></div>
| + | CEILING(number, significance) |
| − | ----
| |
| − | <div id="2SpaceContent" align="left"><div class="ZEditBox" align="justify">
| |
| | | | |
| − | Examples
| + | For Example, |
| | | | |
| − | </div></div>
| + | CEILING(3.5, 2) ''returns 2''. |
| − | ----
| |
| − | <div id="8SpaceContent" align="left"><div class="ZEditBox" align="justify">'''<font face="Times New Roman">''''''''''''<font size="6"> </font>''' '''''''''</font>'''</div></div>
| |
| − | ----
| |
| − | <div id="11SpaceContent" align="left"><div class="ZEditBox mceEditable" align="justify">
| |
| | | | |
| − | <font size="5">Description</font>
| + | CEILING(-4.6, -2) ''returns -4''. |
| | | | |
| − | </div></div>
| + | *Calci returns an NaN error message if the argument is nonnumeric. |
| − | ----
| + | *Calci returns an #ERROR message if 'number' and 'significance' have different signs. |
| − | <div id="10SpaceContent" class="zcontent" align="left"><div class="ZEditBox" align="justify">'''<font face="Times New Roman"> <font size="6">CEILING</font> </font>'''</div></div>
| + | *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. |
| − | <div id="3SpaceContent" class="zcontent" align="left"><br /><div id="7Space" class="gamizbox" title="7Space"><div id="7SpaceHeader" class="zheaderstyle" title="Double-click to start and stop editing the header."><center></center></div><div id="7SpaceRollup" title="Double-click to rolldown" align="left"><span><span id="7SpaceRollupContent" align="center"></span></span></div><div id="7SpaceCover"><div id="7SpaceContent" class="zcontent" align="left"><div class="ZEditBox" align="justify">
| + | *This function can also be used for array of numbers in form of equation as- |
| | | | |
| − | <font size="3"><font face="Times New Roman">CEILING (N, Signi)</font></font>
| + | 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.3,4.3,5.3,6.3'' as output. |
| | | | |
| − | <font size="3"><font face="Times New Roman">Where N is the value to round up and Signi is to signify the round.</font></font>
| + | 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 4,4,6'' as output. |
| | | | |
| − | </div></div>
| + | == Examples == |
| − | ----
| |
| − | <div id="13SpaceContent" class="zcontent" align="left"><br /><br /><div id="1Space" class="gamizbox" title="1Space"><div id="1SpaceHeader" class="zheaderstyle" title="Double-click to start and stop editing the header."><center></center></div><div id="1SpaceRollup" title="Double-click to rolldown" align="left"><span><span id="1SpaceRollupContent" align="center"></span></span></div><div id="1SpaceCover"><div id="1SpaceContent" class="zcontent" align="left"><div class="ZEditBox" align="justify"><font face="Times New Roman"><font size="1"> </font><font size="3">CEILING calculates an error value when number and significance have different signs. </font></font>
| |
| | | | |
| − | <font size="3" face="Times New Roman"> </font>
| |
| − |
| |
| − | </div></div>
| |
| − | ----
| |
| − | <div id="14SpaceContent" class="zcontent" align="left"><br /><br /><br /><div id="5Space" class="gamizbox" title="5Space"><div id="5SpaceHeader" class="zheaderstyle" title="Double-click to start and stop editing the header."><center></center></div><div id="5SpaceRollup" title="Double-click to rolldown" align="left"><span><span id="5SpaceRollupContent" align="center"></span></span></div><div id="5SpaceCover"><div id="5SpaceContent" class="zcontent" align="left"><div class="ZEditBox" align="justify">
| |
| − |
| |
| − | <font size="3"><font face="Times New Roman">Calci returns the number rounds up, to the nearest multiple of implication. </font></font>
| |
| − |
| |
| − | </div></div>
| |
| − | ----
| |
| − | <div id="12SpaceContent" class="zcontent" align="left"><br /><br /><br /></div></div>
| |
| − | ----
| |
| | <div id="6SpaceContent" class="zcontent" align="left"> | | <div id="6SpaceContent" class="zcontent" align="left"> |
| | | | |
| | {| id="TABLE3" class="SpreadSheet blue" | | {| id="TABLE3" class="SpreadSheet blue" |
| | |- class="even" | | |- class="even" |
| − | | class=" " |
| + | | class=" " | '''Function''' |
| − | <div id="6Space_Copy" title="Click and Drag over to AutoFill other cells."></div>
| + | | class=" " | '''Output''' |
| − | | Column1
| |
| − | | class=" " | Column2
| |
| − | | class=" " | Column3 | |
| − | | class=" " | Column4 | |
| | |- class="odd" | | |- class="odd" |
| − | | class=" " | Row1 | + | | class="sshl_f" |CEILING(55.55,5) |
| − | | class=" " | -1.5
| + | | class="sshl_f" |55 |
| − | | class="sshl_f " | -3 | |
| − | | class="sshl_f" |
| |
| − | | class="sshl_f" |
| |
| | |- class="even" | | |- class="even" |
| − | | class=" " | Row2
| + | | class="sshl_f" |CEILING(1000.34,3) |
| − | | class="sshl_f" | -3 | + | | class="sshl_f" |999 |
| − | | class="sshl_f" | | |
| − | | class="sshl_f" |
| |
| − | | class="sshl_f" |
| |
| | |- class="odd" | | |- class="odd" |
| − | | Row3
| + | | class="sshl_f" |CEILING(22.3) |
| − | | class="sshl_f SelectTD SelectTD" | | + | | class="sshl_f" |22 |
| − | <div id="6Space_Handle" title="Click and Drag to resize CALCI Column/Row/Cell. It is EZ!"></div><div id="6Space_Copy" title="Click and Drag over to AutoFill other cells."></div>
| |
| − | | class="sshl_f" |
| |
| − | | class="sshl_f" |
| |
| − | | class="sshl_f" | | |
| | |- class="even" | | |- class="even" |
| − | | Row4
| + | | class="sshl_f" |CEILING(-143.56,-1) |
| − | | class="sshl_f" | | + | | class="sshl_f" |-143 |
| − | | class="sshl_f" |
| |
| − | | class="sshl_f" |
| |
| − | | class="sshl_f" |
| |
| − | |- class="odd"
| |
| − | | class=" " | Row5
| |
| − | | class="sshl_f" |
| |
| − | | class="sshl_f" |
| |
| − | | class="sshl_f" | | |
| − | | class="sshl_f" |
| |
| − | |- class="even" | |
| − | | Row6
| |
| − | | class="sshl_f" |
| |
| − | | class="sshl_f" |
| |
| − | | class="sshl_f" |
| |
| − | | class="sshl_f" |
| |
| | |} | | |} |
| | | | |
| − | <div align="left">[[Image:calci1.gif]]</div></div>
| + | == See Also == |
| − | ----
| + | |
| − | <div id="9SpaceContent" class="zcontent" align="left">
| + | *[[Manuals/calci/FLOOR | FLOOR]] |
| | + | |
| | + | *[[Manuals/calci/INT| INT]] |
| | | | |
| − | <font face="Times New Roman">Lets see an example in (Column1, Row 1 and Column 2, Row1)</font>
| + | *[[Manuals/calci/ROUND | ROUND]] |
| | | | |
| − | CEILING (A, B)
| + | *[[Manuals/calci/ROUNDUP | ROUNDUP]] |
| | | | |
| − | <font face="Times New Roman">CEILING (C1R1, C2R1)''''''</font>
| + | *[[Manuals/calci/ROUNDDOWN | ROUNDDOWN]] |
| | | | |
| − | '''<font face="Times New Roman"> </font>'''
| + | *[[Manuals/calci/TRUNC| TRUNC]] |
| | | | |
| − | That is CEILING (-1.5, -3) is -3
| + | ==References== |
| | | | |
| − | </div></div>
| + | *[http://en.wikipedia.org/wiki/Rounding#Tie-breaking Rounding] |
| − | ----
| + | *[http://http://en.wikipedia.org/wiki/Floor_and_ceiling_functions CEILING Function] |
| − | </div></div></div></div></div></div></div>
| |