DELTA
Tests whether two values are equal.
EngineeringEngineering & Science
What it does
Returns 1 if two numbers are equal, otherwise 0 (Kronecker delta).
Syntax
DELTA(number1, [number2])
Arguments
number1(number) — First number.number2(number) — Second number (default 0).
Examples
Check Equality
Check if 5 equals 4+1.
FORMULA
=DELTA(5, 4+1)
RESULT
1
SAMPLE DATA
| A | B | |
|---|---|---|
| 1 | A | B |
| 2 | 5 | 5 |