Tests whether two values are equal.
פונקציה זו פועלת ב-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.