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

50,645 (131,170)

1,775 (4,597)

7

570,641 (1,477,950)

94,743 (245,383)

1

113,594 (294,207)

396 (1,026)

9

52,035 (134,770)

1,143 (2,960)

4

155,779 (403,466)

7,916 (20,502)

53

103,642 (268,432)

452 (1,171)

7

4,842 (12,541)

701 (1,816)

5

1,949 (5,048)

540 (1,399)

1

53,625 (138,888)

12,133 (31,424)

27

57,513 (148,958)

1,912 (4,950)

14

6,423 (16,635)

4,509 (11,678)

2

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