How to Use the DELTA Function in Excel

Below is a comprehensive guide on utilizing the DELTA function in both Microsoft Excel and Google Sheets.

Overview

The DELTA function is used to compare two numeric values. It returns 1 if the values are equal and 0 if they are not. This functionality is particularly useful for conditional formatting and logical tests within spreadsheets.

Syntax

The syntax for the DELTA function is consistent across both Excel and Google Sheets:

=DELTA(number1, [number2])
  • number1: The first number, or a reference to a cell containing the number, that you want to compare.
  • number2 (optional): The second number, or a reference to a cell containing the number, to compare against. If this argument is omitted, the function will assume it to be 0.

Examples

Example 1:

Comparing two numbers:

A B Result
10 10 =DELTA(A2, B2)

In this case, the formula returns 1 because the values are equal.

Example 2:

Utilizing DELTA in conditional formatting:

Assume you have a series of numbers in column A and wish to highlight cells where the number equals 5. Employ the following custom formula for conditional formatting:

=DELTA(A1, 5)

This formula will highlight cells containing the number 5.

Example 3:

Incorporating DELTA in logical operations:

The DELTA function can be integrated with other functions for enhanced logical operations. Consider the following example:

=IF(DELTA(A1, 10), "Equal", "Not Equal")

This expression results in “Equal” if cell A1 contains the number 10; otherwise, it produces “Not Equal”.

This guide should help you efficiently leverage the DELTA function in Excel and Google Sheets to evaluate equality of values and enhance your data management and analysis tasks.

More information: https://support.microsoft.com/en-us/office/delta-function-2f763672-c959-4e07-ac33-fe03220ba432

Other functions
Returns the modified Bessel function In(x)
Returns the Bessel function Jn(x)
Returns the modified Bessel function Kn(x)
Returns the Bessel function Yn(x)
Converts a binary number to decimal
Converts a binary number to hexadecimal
Converts a binary number to octal
Returns a 'Bitwise And' of two numbers
Returns a value number shifted left by shift_amount bits
Returns a bitwise OR of 2 numbers
Returns a value number shifted right by shift_amount bits
Returns a bitwise 'Exclusive Or' of two numbers
Converts real and imaginary coefficients into a complex number
Converts a number from one measurement system to another
Converts a decimal number to binary
Converts a decimal number to hexadecimal
Converts a decimal number to octal
Returns the error function
Returns the error function
Returns the complementary error function
Returns the complementary ERF function integrated between x and infinity
Tests whether a number is greater than a threshold value
Converts a hexadecimal number to binary
Converts a hexadecimal number to decimal
Converts a hexadecimal number to octal
Returns the absolute value (modulus) of a complex number
Returns the imaginary coefficient of a complex number
Returns the argument theta, an angle expressed in radians
Returns the complex conjugate of a complex number
Returns the cosine of a complex number
Returns the hyperbolic cosine of a complex number
Returns the cotangent of a complex number
Returns the cosecant of a complex number
Returns the hyperbolic cosecant of a complex number
Returns the quotient of two complex numbers
Returns the exponential of a complex number
Returns the natural logarithm of a complex number
Returns the base-10 logarithm of a complex number
Returns the base-2 logarithm of a complex number
Returns a complex number raised to an integer power
Returns the product of complex numbers
Returns the real coefficient of a complex number
Returns the secant of a complex number
Returns the hyperbolic secant of a complex number
Returns the sine of a complex number
Returns the hyperbolic sine of a complex number
Returns the square root of a complex number
Returns the difference between two complex numbers
Returns the sum of complex numbers
Returns the tangent of a complex number
Converts an octal number to binary
Converts an octal number to decimal
Converts an octal number to hexadecimal