CEILING.PRECISE
TheCEILING.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.
 How to use
CEILING.PRECISE
formula?  Examples of using
CEILING.PRECISE
formula CEILING.PRECISE
formula not working? Similar formulas to
CEILING.PRECISE
Usage
Use the 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.
Examples
Here are a few example use cases that explain how to use theCEILING.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 theplaces
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.