CEILING
TheCEILING
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.
 How to use
CEILING
formula?  Examples of using
CEILING
formula CEILING
formula not working? Similar formulas to
CEILING
Usage
Use the CEILING
formula with the syntax shown below, it has 1 required parameter and 1 optional parameter:
 value (required):
The number to be rounded up.  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 theCEILING
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.
Adjusting inventory levels
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 nonnumeric value for the value argument
Another mistake when using the CEILING formula is to use a nonnumeric 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 nonnumeric 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 nonnumeric 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.
Related Formulas
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.
Learn More
You can learn more about the CEILING
Google Sheets function on Google Support.