=CEILING
The =CEILING() function returns the smallest integer value that is greater than or equal to the specified number.
Syntax
Section titled “Syntax”=CEILING(AnyNumber)Parameters
Section titled “Parameters”-
AnyNumber
- The numeric value you want to round up to the nearest integer.
How It Works
Section titled “How It Works”-
Evaluates the provided number and rounds it up to the nearest whole number.
-
If the number is already an integer, it returns the same number.
Usage Notes
Section titled “Usage Notes”-
Only numeric values are supported.
-
Useful for rounding up decimal numbers in calculations and workflows.
-
Formula functions are case sensitive and must be in all caps.
Example
Section titled “Example”=CEILING(3.2)- Returns: 4
Keywords
Section titled “Keywords”CEILING, round up, nearest integer, numeric rounding, formula function, number rounding, workflow calculations, mathematical function