DELTA(n1,n2)
- Where 'n1' is the first number and 'n2' is the second number.
DELTA() compares the two numbers to find if they are equal. Displays '1' if n1 and n2 are equal, else displays '0'.
Description
DELTA(n1,n2)
For Example,
DELTA(5,5) returns 1
DELTA(3.3,4.4) returns 0
DELTA(0) returns 1
- Calci returns '1' if n1=n2 and returns '0' if n1<>n2.
- Calci displays an #ERROR message if numbers are non-numeric.
- 'n2' is optional. If not mentioned, Calci considers it as '0'.
- This function is also called as Kronecker Delta Function.
Examples
Function | Output |
DELTA(76,54) | 0 |
DELTA(1000,1000) | 1 |
DELTA(0.005,5) | 0 |
DELTA(-200,-200) | 1 |
DELTA(30) | 0 |
DELTA(0) | 1 |