DELTA function
From Apache OpenOffice Wiki
< Documentation | How Tos
The printable version is no longer supported and may have rendering errors. Please update your browser bookmarks and please use the default browser print function instead.
Trigonometric
Hyperbolic
Rounding and remainders
Logarithm/Powers
Bessel functions
Miscellaneous
< {{#switch:Previous Page | Previous Section = Previous Section | Next Section = Next Section | Previous Page = Previous Page | Next Page = Next Page | }} | {{#switch:Next Page | Previous Section = Previous Section | Next Section = Next Section | Previous Page = Previous Page | Next Page = Next Page | }} > |
DELTA
Returns 1 if two numbers are equal, and 0 otherwise.
This function is only available if the Analysis AddIn is installed.
Syntax:
DELTA(number1; number2)
- number1 and number2 are numbers. If number2 is omitted, it is assumed to be 0.
- This function is an implementation of the (mathematical) Kronecker delta function.
- number1=number2 returns TRUE or FALSE instead of 1 or 0, but is otherwise identical for number arguments.
Example:
DELTA(4; 5)
- returns 0.
DELTA(4; A1)
- where cell A1 contains 4, returns 1.
DELTA(0)
- returns 1.
=4=5
- in a cell shows FALSE, as 4 is not equal to 5.
Issues:
- DELTA should only be used with numbers - see Issue 86283 .
- DELTA currently appears in the AddIn category of the Function Wizard.
{{#switch:EN
| RU = Смотрите также:
| UA = Дивіться також:
| EN = See Also
| PT = Ver também
| #default = See Also
}}