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

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.

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.

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