Compare two numeric values, returning 1 if they're equal. Learn more
The DELTA() function in Google Sheets is a built-in function that compares two numeric values and returns 1 if they are equal or 0 if they are not equal.
The function takes one required argument, number1, and one optional argument, number2. The first argument, number1, is the value you want to compare, and the second argument, number2, is the value you want to compare it to. If you omit the second argument, the function assumes that number2 is zero.
Here's the syntax for using the DELTA() function in Google Sheets:
=DELTA(number1, [number2])
Examples:
=DELTA(5, 5) returns 1 =DELTA(5, 10) returns 0 =DELTA(10) returns 0 (because it compares 10 to 0 by default)