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.