DELTA(number1, number2)

Returns the numerical value indicating if two numbers are equal.

number1The first number.
number2The second number.

Remarks

* If any of the arguments are not numeric, then #VALUE! is returned.
* If "number1" = "number2", then 1 is returned.
* If "number1" <> "number2", then 0 is returned.
* If "number2" is left blank, then 0 is used.
* This function is often used to help filter out values.
* This function is also known as the Kronecker Delta function.
* In Excel 2003 this function was only available when you had the Analysis ToolPak add-in loaded.
* For the Microsoft documentation refer to support.office.com

 A
1=DELTA(5,4) = 0
2=DELTA(5,5) = 1
3=DELTA(12.3,12.3) = 1
4=DELTA(0,0) = 1
5=DELTA(0) = 1
6=DELTA(1) = 0
7=DELTA("some text",5) = #VALUE!
8=DELTA(5,"some text") = #VALUE!


© 2019 Better Solutions Limited. All Rights Reserved. © 2019 Better Solutions Limited Top