DELTA
Formulas / DELTACompare two numeric values.
=DELTA(number1, [number2])
- number1 - required, the first number
- number2 - [OPTIONAL] the second number
Examples
=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.
Summary
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.
- The DELTA function can be used to compare two numeric values to check if they are equal.
- The DELTA function can be used to compare two numbers when there are equal numbers scattered throughout a workbook.
Frequently Asked Questions
What is the DELTA function?
What is the DELTA function used for?
How do I use the DELTA function?
What is the syntax for the DELTA function?
- DELTA(x, y) = 0 if x ≠y
- DELTA(x, y) = 1 if x = y
