Sunday, 22 July 2012

Excel CEILING Function Syntax and Example

CEILING Function :
The CEILING function rounds a number up to the nearest specified multiple. 

Syntax:

 =CEILING(number,multiple) 

Examples:



NUMBER
Significance/Multiple
CEILING Function
Result
10
4
 =CEILING(A2,B2)
12
25.65
7
 =CEILING(A3,B3)
28
-99
-10
 =CEILING(A4,B4)
-100
25.65
-0.5
 =CEILING(A5,B5)
#NUM!
-25.65
0.5
 =CEILING(A6,B6)
-25.5

Explanation :
In above example "=CEILING(10,4)" = 12 , because the nearest multiple of '4' which is greater than the number '10' is 12.

Note: 

The number argument and the multiple argument must have the same sign or the function will return a #NUM! error. 

No comments:

Post a Comment

Follow Me by Email

ExcelKingdom-Popular Posts

ExcelKingdom-Random Posts