SQRTPI
Name
SQRTPI (multiple)
Definition
Returns the positive square root of a multiple of pi(p).
Syntax
- where the multiple argument is a positive numeric value, that you want to multiply by pi, before calculating the square root.
Note :
- If the multiple provided is < 0, you get #NUM! error
- If the multiple provided is non-numeric , you get #VALUE!
Step 1 : In order to use the SQRTPI formula, start with your edited Excellentable
Step 2 : Then type in the SQRTPI Formula in the area you would like to display the outcome:
Step 3 : Type in the complete SQRTPI 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 the SQRTPI Formula:
- If the multiple argument is negative,
- If the multiple argument provided is non-numeric,
