ISO.CEILING
TheISO.CEILING
function rounds a number up to the nearest integer or to the nearest multiple of a specified significance, whichever is greater. This function is often used in financial calculations where values must be rounded up to adhere to specific regulations or standards.
 How to use
ISO.CEILING
formula?  Examples of using
ISO.CEILING
formula ISO.CEILING
formula not working? Similar formulas to
ISO.CEILING
Usage
Use the ISO.CEILING
formula with the syntax shown below, it has 1 required parameter and 1 optional parameter:
 number (required):
The value to be rounded up.  significance (optional):
The multiple to which to round up. If omitted, the number is rounded up to the nearest integer.
Examples
Here are a few example use cases that explain how to use theISO.CEILING
formula in Google Sheets.
Rounding up to the nearest multiple
Use ISO.CEILING
to round a number up to the nearest multiple of a specified value. For example, if you need to round up to the nearest 10, use ISO.CEILING(A1, 10)
.
Rounding up for financial calculations
Use ISO.CEILING
to round values up to meet financial regulations or standards. For example, some tax laws require certain values to be rounded up to the nearest dollar.
Calculating project timelines
Use ISO.CEILING
to round up time values to the nearest hour or day. This can be useful when calculating project timelines or billing hours.
Common Mistakes
ISO.CEILING
not working? Here are some common mistakes people make when using the ISO.CEILING
Google Sheets Formula:
Incorrect number of arguments
Users may forget to provide one or both of the required arguments for the ISO.CEILING formula. Ensure that both the number and significance arguments are included in the formula.
Invalid input type
The number and significance arguments must be numerical values. Ensure that the input types are correct and there are no additional characters or spaces in the formula.
Incorrect use of decimal places
The significance argument must be a positive integer. Users may accidentally include decimal places or negative values in the significance argument, which will produce an error. Ensure that the significance argument is a positive integer.
Incorrect rounding
The ISO.CEILING formula rounds up to the nearest multiple of the significance argument. If the number is already a multiple of the significance argument, it will not be rounded up. Ensure that the rounding is correct and matches the desired output.
Misunderstanding of ISO standard
The ISO standard for rounding up to a multiple involves rounding up to the next highest multiple, even if the number is already a multiple. Ensure that the user understands this standard and uses it correctly in their formula.
Related Formulas
The following functions are similar to ISO.CEILING
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. 
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. 
ROUNDDOWN
The
ROUNDDOWN
formula rounds a number down to a specified number of decimal places. It is commonly used in financial calculations, such as calculating the total cost of a purchase including tax. The formula takes a requiredvalue
parameter and an optionalplaces
parameter specifying the number of decimal places to round to.
Learn More
You can learn more about the ISO.CEILING
Google Sheets function on Google Support.