How to Use DELTA in Google Sheets in 2020?

DELTACompare two numeric values, returning 1 if they’re equal.

Sample Usage

DELTA(2, 1)


DELTA(B3, 2)


DELTA(number1, [number2])

number1 – the first number to compare.

number2 – [ OPTIONAL – 0 by default ] – the second number to compare.


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.