The DELTA function with example in Excel

In Excel, the DELTA function returns 1 if two supplied numbers are equal and 0 otherwise. This function is useful for creating conditional formulas where you need to check if two values are equal.

The syntax for the DELTA function is:

scss
DELTA(number1, number2)

Where:

• number1 and number2 are the two numbers you want to compare.

Here's an example:

Suppose you have two numbers, 5 and 5, and you want to check if they are equal using the DELTA function.

To do this:

scss
=DELTA(5, 5)

This will return 1 because 5 is equal to 5.

If you check two numbers that are not equal, the function will return 0. For example:

scss
=DELTA(5, 10)

This will return 0 because 5 is not equal to 10.