Check Sheet Logo
Check Sheet

CEILING.PRECISE

The CEILING.PRECISE function returns a number rounded up to the nearest specified multiple. The function takes two arguments: the number to be rounded and the significance or multiple to which the number should be rounded. If the number is already a multiple of the significance, it is returned unchanged. The function is commonly used in financial calculations and can be combined with other functions to perform complex calculations.

Usage

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

=CEILING.PRECISE(number, [significance])
Parameters:
  1. number (required):
    The number to be rounded up to the nearest multiple of the significance.
  2. significance (optional):
    The multiple to which the number should be rounded up. If omitted, significance is assumed to be 1.

Examples

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

Rounding up to the nearest dollar

Use CEILING.PRECISE in conjunction with other functions to round up a number to the nearest dollar. This can be useful in financial calculations where amounts need to be rounded to the nearest whole dollar.

Rounding up to the nearest 5 or 10

Use CEILING.PRECISE to round up to the nearest 5 or 10. This can be useful when working with prices that are always rounded to the nearest 5 or 10 cents.

Calculating commission

Use CEILING.PRECISE to calculate commission on a sale. Commission is often calculated as a percentage of the sale price rounded up to the nearest whole dollar.

Common Mistakes

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

Missing arguments

Users often forget to provide both the number and significance arguments required by the CEILING.PRECISE formula. Make sure to include both arguments in your formula.

Incorrect argument type

The number and significance arguments for the CEILING.PRECISE formula must be numeric. If you see an error message, check that you have provided numeric values for both arguments.

Incorrect order of arguments

The number argument must come before the significance argument in the CEILING.PRECISE formula. Make sure the arguments are in the correct order.

Related Formulas

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

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

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

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

  • ROUND

    The ROUND formula rounds a number to a specified number of decimal places. It is commonly used to simplify large numbers or to make a number more readable. The formula can round both positive and negative numbers. If the places parameter is not specified, the formula rounds to the nearest integer.

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

Learn More

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