Tests whether two values are equal.
Cette fonction fonctionne de la même façon dans Google Sheets que dans Excel — même syntaxe et mêmes arguments.
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)Résultat : 1
Since 5 equals 5, the function returns 1.
=DELTA(5, 2)Résultat : 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.