Home : CEILING
Q11515 - INFO: CEILING

CEILING (Primitive Spread Function) rounds a number up to the nearest multiple of a specified value.

SYNTAX:

CEILING(value1,value2,...)

REMARKS:

Specify the number to round using the value1 argument. Specify the value to use as the rounding factor using the value2 argument. Use either both positive or both negative numbers for the arguments. Regardless of the sign of number, the number is rounded away from zero. 

EXAMPLES:

CEILING(C4,B2)
CEILING(B3,0.05)
CEILING(4.65,2)=6
CEILING(-2.78,-1)=-3

Related Articles
Q11528 - INFO: EVEN
Q11535 - INFO: FLOOR
Q11538 - INFO: INT
Q11569 - INFO: ODD
Q11586 - INFO: ROUND
Q11587 - INFO: ROUNDDOWN
Q11588 - INFO: ROUNDUP
Q11611 - INFO: TRUNC

Article Attachments
No Attachments Available.

Related External Links
No Related Links Available.
Help us improve this article...
What did you think of this article?

poor 
1
2
3
4
5
6
7
8
9
10

 excellent
Tell us why you rated the content this way. (optional)
 
Approved Comments...
No user comments available for this article.
Created on 8/25/2008 2:20 PM.
Last Modified on 8/26/2008 9:53 AM.
Last Modified by No Author Name Available!.
Article has been viewed 3636 times.
Rated 0 out of 10 based on 0 votes.
Print Article
Email Article