DELTA

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.
* For the Microsoft documentation refer to support.microsoft.com
* For the Google documentation refer to support.google.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!


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