Leading the way in Microsoft Office Development
 Home|Excel|Word|PowerPoint|Consultancy|Feedback|Contact 
 Microsoft Excel > Functions > Maths and Trigonometry > CEILING
 

CEILING(number, significance)

 
 Returns the number rounded up to the nearest integer or significant figure.

 numberThe value you want to round up (away from zero).
 significanceThe multiple to which you want to round.

 REMARKS
 
  		• If any of the arguments are not numeric, then #VALUE! is returned.
     
  		• The "number" is rounded up when adjusted away from zero.
     
  		• If "number" is an exact multiple of "significance", then no rounding occurs.
     
  		• If "number" and "significance" have different signs, then #NUM! is returned.
     
  		• Negative numbers are always rounded up away from zero.

     EXAMPLES
     
     A
    1=CEILING(1.1,1) = 2
    2=CEILING(1.5,1) = 2
    3=CEILING(1.9,1) = 2
    4=CEILING(2.5,2) = 4
    5=CEILING(-1.1,-1) = -2
    6=CEILING(-1.5,-1) = -2
    7=CEILING(-1.9,-1) = -2
    8=CEILING(-2.5,-2) = -4
    9=CEILING(8,1.5) = 9
    10=CEILING(8.26,0.05) = 8.3
    11=CEILING(0.234,0.01) = 0.24
    12=CEILING(4,-2) = #NUM!
    13=CEILING(-2.5,2) = #NUM!
    		 
     Functions - C | Index - C | Office Online 

     Copyright © 2004-2007 Better Solutions Limited. All Rights Reserved.Top