DELTA

Excel Functions

Test two values are equal

Syntax

EXCEL

=DELTA(number1, [number2])

Arguments

Parameter	Description
`number1`	The first number.
`number2`	[optional] The second number.

Return Value

The number one or zero

Details

The DELTA function tests two numeric values for equality. When values are equal, DELTA returns 1. When values are different, DELTA returns zero. As a result, DELTA can be used to easily count pairs of equal numbers. For example: In the example shown, the formula in D6, copied down, is:

Examples

Example 1

For example:

EXCEL

=DELTA(5,4) // returns 0
=DELTA(3,3) // returns 1

Example 2

In the example shown, the formula in D6, copied down, is:

EXCEL

=DELTA(B6,C6)