# CEIL

This article will help you understand the CEIL() function and how it can be used to round up an integer value.

## Overview

The CEIL() function returns the nearest positive or negative integer value greater than or equal to the provided decimal input number.

## Syntax

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).

## Examples

### # Case 1: Rounding up a positive decimal value

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.

### # Case 2: Rounding up a negative decimal value

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.

### # Case 3: Using the CEIL() function with a table

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
column with initial decimal values.**numbers** - A
**CeilValue**