=DELTA(number1, [number2])
=DELTA(3,3) returns 1 because the arguments are equal. In this example, the DELTA function is used to compare two numbers (3,3). Since the two arguments are equal, the function returns 1.
=DELTA(5,A6) returns 1 because the arguments are equal. In this example, the DELTA function is used to compare two numbers (5,A6). Since the two arguments are equal, the function returns 1.
=DELTA(A1,A1) returns 1 because the arguments are equal. In this example, the DELTA function is used to compare two cell references (A1,A1). Since the two arguments are equal, the function returns 1.
=DELTA(A2,B2) returns 0 because the arguments are not equal. In this example, the DELTA function is used to compare two cell references (A2,B2). Since the two arguments are not equal, the function returns 0.
The DELTA function is a useful tool for evaluating if two values are equivalent. It is a simple, yet effective way to compare two values.