DELTA
TheDELTA
function returns 1 if two provided numbers are equal, or 0 otherwise. It is commonly used in engineering and math calculations where you need to check if two values are equal.
 How to use
DELTA
formula?  Examples of using
DELTA
formula DELTA
formula not working? Similar formulas to
DELTA
Usage
Use the DELTA
formula with the syntax shown below, it has 1 required parameter and 1 optional parameter:
 number1 (required):
The first number to compare.  number2 (optional):
The second number to compare. If omitted, the function compares number1 to 0.
Examples
Here are a few example use cases that explain how to use theDELTA
formula in Google Sheets.
Check if two values are equal
The DELTA
function can be used to check if two values are equal. For example, you could use it to test if the result of a formula matches a given value.
Calculate a conditional sum
You can use the DELTA
function as part of a larger formula to calculate a conditional sum. For example, you could use it to sum values in a range that match a certain criteria.
Calculate a boolean value
The DELTA
function can be used to calculate a boolean value based on two numerical inputs. For example, you could use it to check if a value is greater than or less than another value.
Common Mistakes
DELTA
not working? Here are some common mistakes people make when using the DELTA
Google Sheets Formula:
Incorrect number of arguments
The DELTA formula requires at least one argument, and at most two arguments. If you get this error, check that you have provided the correct number of arguments.
Nonnumeric arguments
The DELTA formula only works with numeric arguments. If you get this error, check that the values you provided are numbers.
Unexpected output
The DELTA formula returns 1 if the two numbers in the argument are equal, and 0 if they are not equal. If you get unexpected output, check that you have provided the correct numbers.
Using DELTA when not needed
The DELTA formula is used to determine if two numbers are equal. If you do not need to compare two numbers, do not use this formula.
Using DELTA with noninteger values
The DELTA formula only works with integer values. If you need to compare noninteger values, use a different formula.
Related Formulas
The following functions are similar to DELTA
or are often used with it in a formula:

IF
The
IF
formula is a logical function used to test a condition and return one value if the condition is true and another value if the condition is false. It is commonly used to create conditional statements and perform calculations based on certain conditions. 
AND
The
AND
function in Google Sheets is a logical function that returns TRUE if all of the logical expressions in the argument are TRUE, and FALSE if any of the logical expressions are FALSE. It can be used to test multiple conditions and evaluate whether they are all true or not. 
OR
The
OR
formula is a logical formula that returns TRUE if at least one of the provided logical expressions is TRUE. It returns FALSE if all logical expressions are FALSE. This formula is commonly used in conjunction with other logical formulas, such asAND
, to build more complex logical statements.
Learn More
You can learn more about the DELTA
Google Sheets function on Google Support.