# DELTA

### Definition of DELTA

Compare two numeric values, returning 1 if they're equal.

### Sample Usage

`DELTA(2, 1)`

`DELTA(A2)`

`DELTA(B3, 2)`

### Syntax

`DELTA(number1, [number2])`

• `number1` - the first number to compare.

• `number2` - [ OPTIONAL - `0` by default ] - the second number to compare.

### Notes

• If the second argument is not provided then `number1` will be compared to zero.
• A blank cell is treated the same as zero.
• This function only compares numbers. To compare other types of values, use the `EQ` function.

`EQ`: Returns "TRUE" if two specified values are equal and "FALSE" otherwise. Equivalent to the "=" operator.

`IF`: Returns one value if a logical expression is `TRUE` and another if it is `FALSE`.

`SUM`: Returns the sum of a series of numbers and/or cells.

### Once saved, your completed formula will display in a confluence page like this.

A
B
C
D
1
State
 Population
Total area in mi2
Land area in mi2
Water area in mi2
House seat(s)
2
Alabama
4833722
52,420 (135,767)
50,645 (131,170)
3
735132
665,384 (1,723,337)
570,641 (1,477,950)
4
Arizona
6626624
113,990 (295,233)
113,594 (294,207)
5
Arkansas
2959373
53,179 (137,733)
52,035 (134,770)
6
California
38332521
163,695 (423,968)
155,779 (403,466)
7
5268367
104,094 (269,602)
103,642 (268,432)
8
Connecticut
3596080
5,543 (14,356)
4,842 (12,541)
9
Delaware
925749
2,489 (6,446)
1,949 (5,048)
10
Florida
19552860
65,758 (170,312)
53,625 (138,888)
11
Georgia
9992167
59,425 (153,910)
57,513 (148,958)
12
Hawaii
1404054
10,932 (28,314)
6,423 (16,635)
13
Idaho
1612136
83,569 (216,443)
82,643 (214,044)
14
15
E
F
G
1
Date
2
1,775 (4,597)
7
7/5/2008
3
94,743 (245,383)
1
7/6/2009
4
396 (1,026)
9
7/7/2010
5
1,143 (2,960)
4
7/8/2011
6
7,916 (20,502)
53
7/9/2012
7
452 (1,171)
7
7/10/2013
8
701 (1,816)
5
7/11/2014
9
540 (1,399)
1
7/12/2001
10
12,133 (31,424)
27
7/13/2002
11
1,912 (4,950)
14
7/14/2003
12
4,509 (11,678)
2
7/15/2004
13
926 (2,398)
2
7/16/2005
14
15
1

## Other possible outcomes for using the DELTA Formula:

### Non-Numeric Value

JavaScript errors detected