Difference between revisions of "Manuals/calci/CEILING"

 
(One intermediate revision by the same user not shown)
Line 1: Line 1:
=CEILING(number, significance)=
+
<div style="font-size:30px">'''CEILING (Number,Significance) '''</div><br/>
  
*Where 'number' is the numeric value to round and  
+
*Where 'Number' is the numeric value to round and  
*'significance' is the multiple to round the number.
+
*'Significance' is the multiple to round the number.
 
+
**CEILING() rounds the number up, away from zero, to its nearest multiple of significance.
CEILING() rounds the number up, away from zero, to its nearest multiple of significance.
 
  
 
== Description ==
 
== Description ==
  
CEILING(number, significance)
+
CEILING(Number, Significance)
  
 
For Example,
 
For Example,

Latest revision as of 18:35, 13 August 2018

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) 1002
CEILING(22.3) 23
CEILING(-89.45,-2) -90

Related Videos

CEILING

See Also

References