ROUNDUP
Definition
Round a value up to a given number of places.
Syntax
- value - The number to be round up.
places - The number of digits that the value argument will be rounded to.
Notes
- if the argument of places is set to 0, the function rounds the value up to the nearest integer
- If the argument of places is set to 1, the function leaves only one digit to the right of the decimal point and rounds it up to the next number
- if the argument of places is negative, all decimal places are removed and the function rounds up that number of digits to the left of the decimal point upward(i.e. to the nearest 10, 100, 1000, etc.).
Step 1 : In order to use the ROUNDUP formula, start with your edited Excellentable
Step 2 : Then type in the ROUNDUP Formula in the area you would like to display the outcome:
Step 3 : Type in the complete ROUNDUP formula for a cell as shown below:
Step 4 : Excellentable will generate the outcome when hitting enter.
A
|
B
|
C
|
|
|---|---|---|---|
1
|
|||
2
|
|||
3
|
|||
4
|
|||
5
|
|||
6
|
|||
7
|
|||
8
|
|||
9
|
|||
10
|
|||
11
|
|||
12
|
|||
13
|
|||
14
|
|||
15
|
D
|
E
|
F
|
|
|---|---|---|---|
1
|
House seat(s)
2
52,420 (135,767)
50,645 (131,170)
1,775 (4,597)
3
665,384 (1,723,337)
570,641 (1,477,950)
94,743 (245,383)
4
113,990 (295,233)
113,594 (294,207)
396 (1,026)
5
53,179 (137,733)
52,035 (134,770)
1,143 (2,960)
6
163,695 (423,968)
155,779 (403,466)
7,916 (20,502)
7
104,094 (269,602)
103,642 (268,432)
452 (1,171)
8
5,543 (14,356)
4,842 (12,541)
701 (1,816)
9
2,489 (6,446)
1,949 (5,048)
540 (1,399)
10
65,758 (170,312)
53,625 (138,888)
12,133 (31,424)
11
59,425 (153,910)
57,513 (148,958)
1,912 (4,950)
12
10,932 (28,314)
6,423 (16,635)
4,509 (11,678)
13
83,569 (216,443)
82,643 (214,044)
926 (2,398)
14
15
G
|
|
|---|---|
1
|
2
7
3
1
4
9
5
4
6
53
7
7
8
5
9
1
10
27
11
14
12
2
13
2
14
15
Other Possible outcomes for using ROUNDUP Formula
- If the argument of places is 1
- If the argument of places is negative
