CEILING
Returns a number rounded up to a multiple of another given number.
Syntax
number: The number to be rounded up. Eg., -4.37
mult: The multiple to which you want to round the given number. Eg., 2
mode: Mode is used when the given number is negative.
If the mode is non-zero, CEILING rounds up to a multiple greater than or equal to the number.
Remarks
-
The value of the parameter mult cannot be negative when the given number is positive.
-
The value of the parameter mult can be positive or negative when the given number is negative.
Examples
|
Formula |
Result |
|
=CEILING(-4.37; 2; 0) |
-6 |
|
=CEILING(-4.37; 2; 1) |
-4 |
|
=CEILING(3.5;2) |
4 |
In the first example function, CEILING returns -6 the result, because the nearest multiple of 2 that is below the given number (-4.37) is -6.
Possible Errors
|
Errors |
Meaning |
|
#N/A! |
|
|
#NAME! |
|
|
#VALUE! |
|
|
#REF! |
|
|
#NUM! |
|
Similar Functions
Access your files securely from anywhere
Zoho CRM Training Programs
Learn how to use the best tools for sales force automation and better customer engagement from Zoho's implementation specialists.
Zoho DataPrep Personalized Demo
If you'd like a personalized walk-through of our data preparation tool, please request a demo and we'll be happy to show you how to get the best out of Zoho DataPrep.
- Zoho Workerly Home
- Forums
- Connect With Us:
- Zoho Recruit Home
- Forums
- Connect With Us:
Create. Review. Publish.
You are currently viewing the help pages of Qntrl’s earlier version. Click here to view our latest version—Qntrl 3.0's help articles.
Zoho Sheet Resources
Zoho Forms Resources
Zoho Sign Resources
Sign, Paperless!
Zoho TeamInbox Resources
Design. Discuss. Deliver.
Related Articles
FLOOR
Rounds down a given number to a multiple of another number. Syntax FLOOR(number; mult; [mode]) number: The number to round down. Eg., 11.3 mult: The multiple of which to round down the number. This value must be positive. Eg., 2 mode: Mode is ...EVEN
Rounds up a given number to the next even integer, away from zero. Syntax EVEN(number) number: The number you want to round up to the next even integer. Eg., 2.33 Remarks The EVEN function rounds up the given number away from zero, irrespective ...INT
Rounds a number down to the nearest integer. Syntax INT(number) number: The number you want to round down. Eg., 2.3 Examples Formula Result =INT(2.3) 2 =INT(4.66) 4 =INT(-11.2) -12 Get a hands-on experience of the function in the embedded ...ODD
Rounds up a given number to the next odd integer, away from zero. Syntax ODD(number) number: The number you want to round up to the next odd integer. Eg., 2.33 Remarks The ODD function rounds up the given number away from zero, irrespective of ...ROUND
Rounds a decimal number to a specified decimal digits. Syntax ROUND(number; places) number: The number you want to round up. Eg., 2.4456 places: The number of decimal digits to return. Eg., 3 Examples Formula Result =ROUND(2.445631;3) ...