Difference between revisions of "Manuals/calci/CEILING"
Jump to navigation
Jump to search
Line 4: | Line 4: | ||
*'significance' is the multiple to round the number. | *'significance' is the multiple to round the number. | ||
− | CEILING() rounds the number | + | CEILING() rounds the number up, away from zero, to its nearest multiple of significance. |
== Description == | == Description == | ||
Line 12: | Line 12: | ||
For Example, | For Example, | ||
− | CEILING(3.5, 2) ''returns | + | CEILING(3.5, 2) ''returns 4''. |
− | CEILING(-4.6, -2) ''returns - | + | CEILING(-4.6, -2) ''returns -6''. |
*Calci returns an NaN error message if the argument is nonnumeric. | *Calci returns an NaN error message if the argument is nonnumeric. | ||
Line 22: | Line 22: | ||
*This function can also be used for array of numbers in form of equation as- | *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. | + | 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 | + | 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. |
== Examples == | == Examples == | ||
Line 35: | Line 35: | ||
| class=" " | '''Output''' | | class=" " | '''Output''' | ||
|- class="odd" | |- class="odd" | ||
− | | class="sshl_f" |CEILING( | + | | class="sshl_f" |CEILING(67.5,5) |
− | | class="sshl_f" | | + | | class="sshl_f" |70 |
|- class="even" | |- class="even" | ||
| class="sshl_f" |CEILING(1000.34,3) | | class="sshl_f" |CEILING(1000.34,3) |
Revision as of 17:01, 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 up, away from zero, to its nearest multiple of significance.
Description
CEILING(number, 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.