Difference between revisions of "Manuals/calci/CEILING"

From ZCubes Wiki
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 down towards zero, to its nearest multiple of significance.
+
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 2''.
+
CEILING(3.5, 2) ''returns 4''.
  
CEILING(-4.6, -2) ''returns -4''.
+
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.3,4.3,5.3,6.3'' as output.
+
   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 4,4,6'' 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.  
  
 
== Examples ==
 
== Examples ==
Line 35: Line 35:
 
| class="  " | '''Output'''
 
| class="  " | '''Output'''
 
|- class="odd"
 
|- class="odd"
| class="sshl_f" |CEILING(55.55,5)
+
| class="sshl_f" |CEILING(67.5,5)
| class="sshl_f" |55
+
| 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. 

Examples

Function Output
CEILING(67.5,5) 70
CEILING(1000.34,3) 999
CEILING(22.3) 22
CEILING(-143.56,-1) -143

See Also

References