Función de Google Sheets

DELTA

Tests whether two values are equal.

Generar una fórmula con IA La misma función en Excel

Esta función funciona igual en Google Sheets que en Excel: misma sintaxis y mismos argumentos.

Sintaxis

DELTA(number1, [number2])

The DELTA function returns 1 if two numbers are equal and 0 otherwise. It is commonly used to filter a set of values or to perform conditional calculations based on numerical equality.

Argumentos

number1obligatorioThe first number to compare.
number2opcionalThe second number to compare; if omitted, it defaults to 0.

Ejemplos

=DELTA(5, 5)

Resultado: 1

Since 5 equals 5, the function returns 1.

=DELTA(5, 2)

Resultado: 0

Since 5 does not equal 2, the function returns 0.

Preguntas frecuentes

What happens if I omit the second number?

If you omit number2, the function assumes it is 0 and compares number1 against 0.

Funciones relacionadas

IF EXACT SUMPRODUCT