Tests whether two values are equal.
구문
DELTA(number1, [number2])인수
number1필수
The first number to compare.
number2선택
The second number to compare; if omitted, it defaults to 0.
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.
=DELTA(5, 5)→1Since 5 equals 5, the function returns 1.
=DELTA(5, 2)→0Since 5 does not equal 2, the function returns 0.
Select a cell
Click on the cell where you want to display the result.
Enter the formula
Type =DELTA(number1, number2) and replace the arguments with your specific values or cell references.
Press Enter
Press Enter to calculate the result.
If you omit number2, the function assumes it is 0 and compares number1 against 0.