Difference between revisions of "Documentation/How Tos/Calc: DELTA function"

Revision as of 07:38, 17 July 2018

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.

• GESTEP

• Mathematical functions

• Information functions

• Functions listed alphabetically
• Functions listed by category