Home › Functions › Engineering › DELTA
fx
DELTA
Engineering  ·  Since: Excel 2003  ·  9 languages

Tests whether two values are equal. Returns 1 if number1 = number2; returns 0 otherwise. Use this function to filter a set of values. For example, by summing several DELTA functions you calculate the count of equal pairs. This function is also known as the Kronecker Delta function.

🌐 Translations

English DELTA
Deutsch DELTA
Français DELTA
Español DELTA
Italiano DELTA
Português DELTA
Nederlands DELTA
Polski CZY.RÓWNE
Русский ДЕЛЬТА

📦 Availability

Excel versionAvailable
Excel 2007 ✓
Excel 2013 ✓
Excel 2019 ✓
Excel 2021 ✓
Microsoft 365 ✓
Translate a formula with this function
fx EN
fx DE

⌨ Syntax

DELTA(number1,[number2])

Arguments

number1 (required) — The first number.
number2 (optional) — The second number. If omitted, number2 is assumed to be zero.

▶ Examples

=DELTA(5,4)
=DELTA(5,5)
=DELTA(0.5,0)

Related functions

Copied to clipboard