Functions
DELTA
Test whether two values are equal
Try it
When to use it
When should I use DELTA?
Use DELTA to test whether two numbers are equal, returning 1 if they are and 0 if they are not — useful for counting matches or building conditional sums without IF.
Used in
Syntax
DELTA(number1, [number2])Examples
=DELTA(2,2) // => 1
=DELTA(2,1) // => 0
=DELTA(0) // => 1