この関数は Google スプレッドシートでも Excel と同じように機能します。構文も引数も同じです。
DELTA(number1, [number2])The DELTA function returns 1 if two numbers are equal and 0 otherwise. It is commonly used to filter a set of values or to perform conditional calculations based on numerical equality.
=DELTA(5, 5)結果: 1
Since 5 equals 5, the function returns 1.
=DELTA(5, 2)結果: 0
Since 5 does not equal 2, the function returns 0.
If you omit number2, the function assumes it is 0 and compares number1 against 0.