Compare 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.

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.

Clear search
Close search
Google apps
Main menu