CEILING

• 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:

=CEILING(value, [factor])

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

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

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.

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.