이 함수는 Google Sheets에서도 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.