Menu
EXCEL DELTA FUNCTION
Excel DELTA Function Introduction
The Excel Delta function compares two values and returns the Kronecker Delta. In other words, if the two provided values are equal, the function returns 1; otherwise, it returns 0.
Description of Excel DELTA Function
Syntax :
=DELTA(number1, [number2])
Parameters :
- Here number1 and [number2] are the numbers to be compared The [number2] parameter is optional, and if omitted, the value 0 is used.
Step By Step Guide of DELTA Function
Example :
The spreadsheets below demonstrate five uses of the Excel Delta function. The second parameter, [number2], is removed from the functions in cells A4 and A5 in the preceding sample spreadsheet. As a result, these two functions compare the given number1 value to zero.
Key Points
- #VALUE!-This error occurs when one or both of the given number parameters are non-numeric.
Related Functions
HLOOKUP Function
HLOOKUP Function
Explore NowVLOOKUP Function
VLOOKUP Function
Explore NowINDEX Function
INDEX Function
Explore NowMATCH Function
MATCH Function
Explore NowDATE Function
DATE Function
Explore NowIF Function
IF Function
Explore NowOR Function
OR Function
Explore NowAND Function
AND Function
Explore NowRANK Function
RANK Function
Explore NowSUMIF Function
SUMIF Function
Explore NowXIRR Function
XIRR Function
Explore NowWORKDAYS Function
WORKDAYS Function
Explore Now
