Log In
IBM Docs wiki
All Wikis
All Forums
Home
Product Documentation
Community Articles
Learning Center
IBM Redbooks
API Documentation
Community Articles
Product Documentation
Learning Center
IBM Redbooks
API Documentation
This category
Custom Search Scope...
Search
Share
▼
Subscribe
▼
Share
▼
Subscribe
▼
Installing and deploying IBM Docs 1.0.3
Select version
1.0.3 Installing and Deploying
1.0.3 Using IBM Docs
Using IBM Docs 1.0.3 documentation
Information
You are currently viewing machine translated content. IBM translation might be available. Click
IBM Translated Product Documentation
to see what is available.
X
CEILING function
Added by
IBM
on
June 24, 2013

Version 1
(
Original
)
Edit
More Actions
▼
Abstract
Abstract
CEILING rounds a number up to the nearest multiple of significance.
Syntax
CEILING(
number
,
increment
,
mode
)
number
is the number that is to be rounded.
increment
is the number to whose multiple the value is to be rounded.
mode
is an optional value. If the
mode
value is given and not equal to zero, and if
number
and
increment
are negative, rounding is done based on the absolute value of
number
. This mode argument is ignored when exporting to Microsoft Excel because it does not use a third parameter.
Important:
If both
number
and
increment
are negative and the
mode
value is equal to zero or is not given, the results in IBM Docs and Microsoft Excel differ after the import is complete. If you export the spreadsheet to Excel, use mode=1 to see the same results in Excel as in IBM Docs.
Example
=CEILING(11,2)
returns
10
.
=CEILING(11,2,0)
returns
10
.
=CEILING(11,2,1)
returns
12
.
Parent topic:
Functions
Related reference
Mathematical functions
Edit
More Actions
▼
Attachments (0)
Attachments (0)
Edit the article to add or modify attachments.
Versions (1)
Versions (1)
Version Comparison
Compare version
Current 1
with version
Current 1
Compare selected versions
Version
Date
Changed by
Summary of changes
This version (1)
Jun 24, 2013 9:54:14 PM
IBM
Comments (0)
Comments (0)
Add comment
Copy and paste this wiki markup to link to this article from another article in this wiki.
Link:
Close