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	State	Revenue	Population	Total area in mi2	Land area in mi2	Water area in mi2
2	Alabama	2.4	4833722
3	Alaska	242.2413	735132
4	Arizona	23.765	6626624
5	Arkansas	-56.58	2959373
6	California	-0.5	38332521
7	Colorado	3.2	5268367
8	Connecticut	76.9	3596080
9	Delaware	3.14159	925749
10	Florida	-3.141	19552860
11	Georgia	-242.2413	9992167
12	Hawaii	3141.59	1404054
13	Idaho	0.5	1612136
14
15		-57

	D	E	F
1

House seat(s)

52,420 (135,767)

50,645 (131,170)

1,775 (4,597)

665,384 (1,723,337)

570,641 (1,477,950)

94,743 (245,383)

113,990 (295,233)

113,594 (294,207)

396 (1,026)

53,179 (137,733)

52,035 (134,770)

1,143 (2,960)

163,695 (423,968)

155,779 (403,466)

7,916 (20,502)

104,094 (269,602)

103,642 (268,432)

452 (1,171)

5,543 (14,356)

4,842 (12,541)

701 (1,816)

2,489 (6,446)

1,949 (5,048)

540 (1,399)

65,758 (170,312)

53,625 (138,888)

12,133 (31,424)

59,425 (153,910)

57,513 (148,958)

1,912 (4,950)

10,932 (28,314)

6,423 (16,635)

4,509 (11,678)

83,569 (216,443)

82,643 (214,044)

926 (2,398)

7

1

9

4

53

7

5

1

27

14

2

2

Other Possible outcomes for using ROUNDUP Formula

1. If the argument of places is 1
   
   

   

   
   
   

   

   
   
   
2. If the argument of places is negative