DELTA

The DELTA function is used to test whether two values are equal. It returns 1 if the values are equal, and 0 if they are not equal. This function is handy for comparing two values and performing conditional logic based on the result.

Syntax

=DELTA(number1, number2)

number1 The first value you want to compare.
number2 The second value you want to compare against the first value.

About DELTA

When you need a simple yet effective way to compare two values in Excel, DELTA comes to the rescue. It's a compact function that swiftly evaluates whether the specified numbers are identical or not. This functionality proves particularly useful in constructing conditional statements or verifying equality between numerical inputs. The ease of use and immediate feedback provided by DELTA streamlines decision-making processes and enhances data validation tasks within your spreadsheets.

Examples

Suppose you have two values in cells A1 and B1, and you want to check if they are equal. You can use the DELTA function as follows: =DELTA(A1, B1) This will return 1 if the values in A1 and B1 are the same, and 0 if they are different.

If you want to compare a constant value to a cell reference, you can use DELTA like this: =DELTA(5, A1) This will return 1 if the value in A1 is 5, and 0 if it's a different value.

Questions

How does the DELTA function determine if two values are equal?

The DELTA function compares the two specified values and returns 1 if they are equal, and 0 if they are not equal. It performs a straightforward numerical equality check and doesn't account for other data types or formats.

Can I compare more than two values using the DELTA function?

No, the DELTA function is designed to compare only two values at a time. If you need to compare multiple values, you would need to nest multiple DELTA functions or explore other Excel functions that support multi-value comparisons.

Is the comparison case-sensitive in the DELTA function?

No, the DELTA function performs a purely numerical comparison and is not case-sensitive. It will return 1 if the numerical values are exactly the same, regardless of their case.

Related functions

IF
IFERROR
IFS
AND
OR
EQUAL
EXACT