The CEIL() function returns the nearest positive or negative integer value greater than or equal to the provided decimal input number.
The syntax of the CEIL() function is as follows:
The CEIL() function requires one argument:
- x: A positive or a negative decimal number (or an expression that evaluates to a decimal number).
The following example demonstrates how the CEIL() function rounds up a positive decimal value:
As shown below, it will return 301, as it is the nearest integer value greater than 300.55.
The following example demonstrates how the CEIL() function rounds up a negative decimal value:
The output of this statement will be -89, as -89 is the nearest integer value greater than or equal to -89.9, as shown below.
The following example demonstrates how the CEIL() function can be used with a table to round up the values in a specific column:
1) First, create a table called CeilRecords with the following query:
The above statement will create a table called "CeilRecords" with a column called "numbers" and insert 5 decimal values into it.
2) The statement below can be used to retrieve and round up the value for all records in the column numbers:
The final result will contain the following:
- A numbers column with initial decimal values.
- A CeilValue column with rounded-up integer values.