Difference between revisions of "Manuals/calci/CEILING"
Jump to navigation
Jump to search
(Created page with "<div id="16SpaceContent" align="left"><div class="ZEditBox" align="justify"> Syntax </div></div> ---- <div id="4SpaceContent" align="left"><div class="ZEditBox" align=...") |
|||
| Line 1: | Line 1: | ||
| − | + | =CEILING(number, significance)= | |
| − | + | *Where 'number' is the numeric value to round and | |
| + | *'significance' is the multiple to round the number. | ||
| − | + | CEILING() rounds the number down towards zero, to its nearest multiple of significance. | |
| − | |||
| − | |||
| − | + | == Description == | |
| − | + | CEILING(number, significance) | |
| − | |||
| − | |||
| − | + | For Example, | |
| − | + | CEILING(3.5, 2) ''returns 2''. | |
| − | |||
| − | |||
| − | |||
| − | |||
| − | + | CEILING(-4.6, -2) ''returns -4''. | |
| − | + | *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.3,4.3,5.3,6.3'' 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 4,4,6'' as output. | |
| − | + | == Examples == | |
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
<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=" " | '''Function''' | |
| − | + | | class=" " | '''Output''' | |
| − | |||
| − | |||
| − | | class=" " | | ||
| − | | class=" " | | ||
|- class="odd" | |- class="odd" | ||
| − | | class=" " | | + | | class="sshl_f" |CEILING(55.55,5) |
| − | + | | class="sshl_f" |55 | |
| − | | class="sshl_f " | | ||
| − | |||
| − | |||
|- class="even" | |- class="even" | ||
| − | + | | class="sshl_f" |CEILING(1000.34,3) | |
| − | | class="sshl_f" | | + | | class="sshl_f" |999 |
| − | | class="sshl_f" | | ||
| − | |||
| − | |||
|- class="odd" | |- class="odd" | ||
| − | + | | class="sshl_f" |CEILING(22.3) | |
| − | | class="sshl_f | + | | class="sshl_f" |22 |
| − | |||
| − | |||
| − | |||
| − | | class="sshl_f" | | ||
|- class="even" | |- class="even" | ||
| − | + | | class="sshl_f" |CEILING(-143.56,-1) | |
| − | | class="sshl_f" | | + | | class="sshl_f" |-143 |
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | | class="sshl_f" | ||
| − | |||
| − | |- | ||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
|} | |} | ||
| − | + | == See Also == | |
| − | + | ||
| − | + | *[[Manuals/calci/FLOOR | FLOOR]] | |
| + | |||
| + | *[[Manuals/calci/INT| INT]] | ||
| − | + | *[[Manuals/calci/ROUND | ROUND]] | |
| − | + | *[[Manuals/calci/ROUNDUP | ROUNDUP]] | |
| − | + | *[[Manuals/calci/ROUNDDOWN | ROUNDDOWN]] | |
| − | + | *[[Manuals/calci/TRUNC| TRUNC]] | |
| − | + | ==References== | |
| − | + | *[http://en.wikipedia.org/wiki/Rounding#Tie-breaking Rounding] | |
| − | + | *[http://http://en.wikipedia.org/wiki/Floor_and_ceiling_functions CEILING Function] | |
| − | |||
Revision as of 15:50, 2 December 2013
CEILING(number, significance)
- Where 'number' is the numeric value to round and
- 'significance' is the multiple to round the number.
CEILING() rounds the number down towards zero, to its nearest multiple of significance.
Description
CEILING(number, significance)
For Example,
CEILING(3.5, 2) returns 2.
CEILING(-4.6, -2) returns -4.
- 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.3,4.3,5.3,6.3 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 4,4,6 as output.