Engineering - DELTA Function

Description

The DELTA function tests whether two values are equal. It returns 1 if number1 = number2; returns 0 otherwise.

You can use this function to filter a set of values. For example, by summing several DELTA functions you calculate the count of equal pairs. This function is also known as the Kronecker Delta function.

Syntax

DELTA (number1, [number2])

Arguments

Argument Description Required/ Optional
number1 The first number. Required
number2

The second number.

If omitted, number2 is assumed to be zero.

 Optional

Notes

  • If number1 is nonnumeric, DELTA returns the #VALUE! error value.

  • If number2 is nonnumeric, DELTA returns the #VALUE! error value.

Applicability

Excel 2007, Excel 2010, Excel 2013, Excel 2016

Example

DELTA Function
advanced_excel_engineering_functions.htm
Advertisements