The Excel DELTA Function

Related Function:
GESTEP 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.

The syntax of the function is :

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.


Further examples of the Excel Delta function can be found on the Microsoft Office website.


Delta Function Errors

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

Common Errors
#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.
You will need to enable the add-in if you want to use the Excel engineering functions.

  +   Show How to Do This in Excel 2003:

  +   Show How to Do This in Excel 2007:

  +   Show How to Do This in Excel 2010:

Return to the Excel Engineering Functions Page

Return to the List of All Built-In Excel Functions

Valid XHTML 1.0 Transitional Valid CSS!
Disclaimer   Privacy Policy
Copyright © 2008-2013 ExcelFunctions.net