Difference between revisions of "Manuals/calci/DELTA"
Jump to navigation
Jump to search
| Line 2: | Line 2: | ||
*Where 'a' is the first number and 'b' is the second number. | *Where 'a' is the first number and 'b' is the second number. | ||
| − | + | **DELTA(), tests whether two values are equal. Displays '1' if a and b are equal, else displays '0'. | |
| − | DELTA(), tests whether two values are equal. Displays '1' if a and b are equal, else displays '0'. | ||
==Description== | ==Description== | ||
Latest revision as of 16:07, 21 August 2018
DELTA (a,b)
- Where 'a' is the first number and 'b' is the second number.
- DELTA(), tests whether two values are equal. Displays '1' if a and b are equal, else displays '0'.
Description
DELTA(a,b)
For Example,
DELTA(5,5) returns 1
DELTA(3.3,4.4) returns 0
DELTA(0) returns 1
- Calci returns '1' if a=b and returns '0' if a<>b.
- Calci displays an #ERROR message if numbers are non-numeric.
- 'b' 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 |
Related Videos
See Also
References