CEILING.PRECISEfunction 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.
- How to use
- Examples of using
CEILING.PRECISEformula not working?
- Similar formulas to
CEILING.PRECISE formula with the syntax shown below, it has 1 required parameter and 1 optional parameter:
- number (required):
The number to be rounded up to the nearest multiple of the significance.
- significance (optional):
The multiple to which the number should be rounded up. If omitted, significance is assumed to be 1.
ExamplesHere are a few example use cases that explain how to use the
CEILING.PRECISEformula in Google Sheets.
Rounding up to the nearest dollar
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
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.
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.
CEILING.PRECISEnot working? Here are some common mistakes people make when using the
CEILING.PRECISEGoogle Sheets Formula:
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.
The following functions are similar to
CEILING.PRECISE or are often used with it in a formula:
CEILINGfunction 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.
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.
MROUNDfunction 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.
ROUNDformula 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
placesparameter is not specified, the formula rounds to the nearest integer.
ROUNDUPformula 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.
You can learn more about the
CEILING.PRECISE Google Sheets function on Google Support.