# CEILING

The `CEILING` function returns a number rounded up to the nearest multiple of a specified factor. It is commonly used to round up prices to the nearest dollar or to adjust numbers to fit into specific increments.

## Usage

Use the `CEILING` formula with the syntax shown below, it has 1 required parameter and 1 optional parameter:

Parameters:
1. value (required):
The number to be rounded up.
2. factor (optional):
The multiple to which the number should be rounded up. If omitted, the default value of 1 is used.

## Examples

Here are a few example use cases that explain how to use the `CEILING` formula in Google Sheets.

### Rounding up to the nearest dollar

To round up a price to the nearest dollar, use the `CEILING` function with a factor of 1.

To adjust inventory levels to fit into specific increments, use the `CEILING` function with a factor equal to the size of the increment.

### Calculating shipping costs

To calculate shipping costs based on weight, use the `CEILING` function to round up the weight of the package to the nearest pound or other unit of measurement.

## Common Mistakes

`CEILING` not working? Here are some common mistakes people make when using the `CEILING` Google Sheets Formula:

### Forgetting to provide the value argument

One common mistake when using the CEILING formula is to forget to provide the value argument. This can result in a #VALUE! error. To fix this, make sure to include the value argument in the formula.

### Using a non-numeric value for the value argument

Another mistake when using the CEILING formula is to use a non-numeric value for the value argument. This can also result in a #VALUE! error. To fix this, make sure the value argument is a numeric value or a reference to a cell containing a numeric value.

### Using a non-numeric value for the factor argument

When using the CEILING formula, it is also important to ensure that the factor argument is a numeric value or a reference to a cell containing a numeric value. Using a non-numeric value for the factor argument can result in a #VALUE! error.

### Using a negative value for the factor argument

The factor argument in the CEILING formula must be a positive number. Using a negative value for the factor argument will result in a #NUM! error. To fix this, make sure to use a positive value for the factor argument.

### Incorrectly rounding up the value

One common mistake when using the CEILING formula is to accidentally round up the value when it should be rounded down. To fix this, make sure to understand the purpose of the CEILING formula and use it appropriately.

The following functions are similar to `CEILING` or are often used with it in a formula:

• `FLOOR`

The FLOOR formula rounds a given number down to the nearest multiple of a specified factor. It is commonly used when dealing with financial data or when working with time values. The function takes a value and an optional factor as arguments and returns the rounded down value.

• `ROUNDUP`

The `ROUNDUP` formula rounds a number up to a specified number of decimal places. It is commonly used to simplify the display of numbers or to perform calculations that require a certain level of accuracy.

• `MROUND`

The `MROUND` function rounds a number to the nearest multiple of a specified factor. It is commonly used when dealing with financial data, such as currency or interest rate calculations.

You can learn more about the `CEILING` Google Sheets function on Google Support.