# CEILING

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

A
B
C
1
State
 Population
Total area in mi2
Land area in mi2
Water area in mi2
2
Alabama
4833722
52,420 (135,767)
3
735132
665,384 (1,723,337)
4
Arizona
6626624
113,990 (295,233)
5
Arkansas
2959373
53,179 (137,733)
6
California
38332521
163,695 (423,968)
7
5268367
104,094 (269,602)
8
Connecticut
3596080
5,543 (14,356)
9
Delaware
925749
2,489 (6,446)
10
Florida
19552860
65,758 (170,312)
11
Georgia
9992167
59,425 (153,910)
12
Hawaii
1404054
10,932 (28,314)
13
Idaho
1612136
83,569 (216,443)
14
15
D
E
F
1
House seat(s)
2
50,645 (131,170)
1,775 (4,597)
7
3
570,641 (1,477,950)
94,743 (245,383)
1
4
113,594 (294,207)
396 (1,026)
9
5
52,035 (134,770)
1,143 (2,960)
4.42
6
155,779 (403,466)
7,916 (20,502)
53
7
103,642 (268,432)
452 (1,171)
7
8
4,842 (12,541)
701 (1,816)
5
9
1,949 (5,048)
540 (1,399)
1
10
53,625 (138,888)
12,133 (31,424)
27
11
57,513 (148,958)
1,912 (4,950)
14
12
6,423 (16,635)
4,509 (11,678)
2
13
82,643 (214,044)
926 (2,398)
2
14
15
CEILING(of 4.42 to the nearest multiple of 0.05):
4.45

JavaScript errors detected