DELTA Function

Basic Description

The Excel Delta function tests two numbers for equality and returns the Kronecker Delta. i.e. the function returns 1 if the two supplied numbers are equal and 0 otherwise.

Syntax: DELTA( number1, [number2] )

where number1 and [number2] are the two numbers to be compared. The [number2] argument is optional, and if omitted, takes on the value 0.

 

Delta Function Examples

four examples of the Excel Delta function are shown in the spreadsheets below. The spreadsheet on the left shows the formulas and the spreadsheet on the left shows the Delta function results.

 Formulas:

Examples of use of the Excel Delta Function

 Results:

Excel Delta Function Results

Note that, in cell A4 the above example spreadsheet, second argument, [number2], is omitted from the function. This function therefore compares the supplied value with zero.

 

Delta Function Errors

If you get an error from the Excel Delta function this is likely to be one of the following :

#VALUE! Occurs if any of the supplied number arguments are not numeric
#NAME? Occurs when Analysis ToolPak add-in is not enabled in your Excel.

Leave a Reply

Your email address will not be published. Required fields are marked *

You may use these HTML tags and attributes: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <s> <strike> <strong>

*

code

clearPost Comment