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.

true
Visit the Learning Center

Using Google products, like Google Docs, at work or school? Try powerful tips, tutorials, and templates. Learn to work on Office files without installing Office, create dynamic project plans and team calendars, auto-organize your inbox, and more.

Search
Clear search
Close search
Google apps
Main menu
6468677425213950836
true
Search Help Center
true
true
true
true
true
35
false
false