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.

See Also

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.

In order to use the DELTA formula, start with your edited Excellentable:

Then type in the DELTA Formula in the area you would like to display the outcome:

By adding the values you would like to calculate the DELTA formula for, Excellentable will generate the outcome:

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	Alaska	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	Colorado	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

1,775 (4,597)

7

94,743 (245,383)

1

396 (1,026)

9

1,143 (2,960)

4

7,916 (20,502)

53

452 (1,171)

7

701 (1,816)

5

540 (1,399)

1

12,133 (31,424)

27

1,912 (4,950)

14

4,509 (11,678)

2

926 (2,398)

2

Other possible outcomes for using the DELTA Formula:

Non-equal Numbers

Non-Numeric Value