### Definition of CEILING

Rounds a number up to the nearest integer multiple of specified significance.

### Sample Usage

`CEILING(23.25,0.1)`

`CEILING(A2,1)`

### Syntax

`CEILING(value, [factor])`

• `value` - The value to round up to the nearest integer multiple of `factor`.

• `factor` - [OPTIONAL - `1` by default] - The number to whose multiples `value` will be rounded.

• `factor` may not be equal to `0`.

### Notes

• `value` and `factor` must have the same sign; that is, they must both be positive or both negative.

• `CEILING` is most often used with `factor` set to a 'round' number such as `0.1` or `0.01` in order to round to a particular decimal place. However, `factor` can, in fact, be any number of the same sign as `value`, e.g. `CEILING(23.25,0.18)` which results in `23.4`, which is 0.18 * 130. This can be used, for instance, to round up to a particular denomination of currency (e.g. 0.25 or 0.05 USD).

`FLOOR`: Rounds a number down to the nearest integer multiple of specified significance.

`TRUNC`: Truncates a number to a certain number of significant digits by omitting less significant digits.

`ROUNDUP`: Rounds a number to a certain number of decimal places, always rounding up to the next valid increment.

`ROUNDDOWN`: Rounds a number to a certain number of decimal places, always rounding down to the next valid increment.

`ROUND`: Rounds a number to a certain number of decimal places according to standard rules.

`MROUND`: Rounds one number to the nearest integer multiple of another.

`INT`: Rounds a number down to the nearest integer that is less than or equal to it.

### By adding the values you would like to calculate, Excellentable generates the outcome:

Error.

User does not have sufficient privileges to access this Content