Skip to main content

SIGN

Definition:

returns the sign (+1, -1 or 0) of a provided cellreference 

Syntax:

  • if the cellreference is positive, the function returns +1,

  • if the cellreference is negative, the function returns -1 

  • if the cellreference is 0 (zero), the function returns 0.


 

Step 1 : In order to use the SIGN formula, start with your edited Excellentable

 

Step 2 : Then type in the SIGN Formula in the area you would like to display the outcome:

 

Step 3 : Type in the complete SIGN formula for a cell as shown below:

 

Step 4 : Excellentable will generate the outcome when hitting enter. 

 

 

A
B
C
D
1
State
Revenue
Population
Total area in mi2
Land area in mi2
Water area in mi2
House seat(s)
2
Alabama
2.4
4833722
52,420 (135,767)
3
Alaska
242.2413
735132
665,384 (1,723,337)
4
Arizona
23.765
6626624
113,990 (295,233)
5
Arkansas
-56.58
2959373
53,179 (137,733)
6
California
-0.5
38332521
163,695 (423,968)
7
Colorado
30
5268367
104,094 (269,602)
8
Connecticut
76.9
3596080
5,543 (14,356)
9
Delaware
3.14159
925749
2,489 (6,446)
10
Florida
-3.141
19552860
65,758 (170,312)
11
Georgia
-242.2413
9992167
59,425 (153,910)
12
Hawaii
3141.59
1404054
10,932 (28,314)
13
Idaho
0
1612136
83,569 (216,443)
E
F
G
1
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
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

 

Other possible outcomes for the SIGN Formula:

 

  1. If the cellreference is positive








  2. If the cellreference is zero





JavaScript errors detected

Please note, these errors can depend on your browser setup.

If this problem persists, please contact our support.