Function Reference: DELTA

Syntax
=DELTA(number1,[number2])
Purpose / Description
Compares two numbers and returns 1 if they are exactly the same, and 0 if they are different.
Arguments
NameTypeDescription
number1numberA constant, reference or nested expression that returns a value to be compared.  If the value is a numeric text string, it is coerced to a number.
[number2]numberAn optional constant, reference or nested expression that returns a second value to be compared to the first.  If the value is a numeric text string, it is coerced to a number.  Defaults to 0 if it is omitted.
Return Values
TypeSpecific ValueDescription
number1Both numbers are the same (after any coercion of numeric text strings required).  If the number2 argument is omitted, it indicates that the value of number1 is 0.
number0The numbers are not the same  If the number2 argument is omitted, it indicates that the value of number1 is non-zero.
error#VALUE!Either the value passed to number1 or number2 is a non-numeric text string or is a logical value.
error Any errors referenced by arguments are returned due to propagation of error values.
Notes / Comments / Advice / Warnings
Note:Only compares numeric values.
Comment:Can be useful in dynamic arrays and filtering formulas.
Examples:Open / download sample workbook: DELTA.xlsx