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:

Capture 2016-04-02 at 17.16.41.png
    


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

Capture 2016-04-03 at 19.50.37.png

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

Capture 2016-04-03 at 19.53.58.png


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

Other possible outcomes for using the DELTA Formula:

Non-equal Numbers

Capture 2016-04-03 at 19.58.21.png
Capture 2016-04-03 at 19.58.26.png

Non-Numeric Value

Capture 2016-04-03 at 19.59.30.png

Capture 2016-04-03 at 19.59.33.png