DELTAfunction 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
- Examples of using
DELTAformula not working?
- Similar formulas to
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.
ExamplesHere are a few example use cases that explain how to use the
DELTAformula in Google Sheets.
Check if two values are equal
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
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.
DELTAnot working? Here are some common mistakes people make when using the
DELTAGoogle 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.
The DELTA formula only works with numeric arguments. If you get this error, check that the values you provided are numbers.
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 non-integer values
The DELTA formula only works with integer values. If you need to compare non-integer values, use a different formula.
The following functions are similar to
DELTA or are often used with it in a formula:
IFformula 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.
ANDfunction 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.
ORformula 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 as
AND, to build more complex logical statements.
You can learn more about the
DELTA Google Sheets function on Google Support.