DELTA

  • Updated

Compares two numeric values. Returns 1 if the arguments are equal, and returns 0 otherwise.

Sample Usage

DELTA(5,4)
DELTA(C5)

Syntax

DELTA(number1, number2)

  • number1 - The first number to compare.
  • number2 - The second number to compare.

Examples

DELTA(5,4) checks if 5 is equal to 4, and returns 0.
DELTA(C5) compares the number contained in C5 with the default value 0.

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.