DELTA
The DELTA
function in Google Sheets is used to compare two numeric values and returns 1 if they are equal.
Function Syntax and Parameters
Syntax: DELTA(number1, [number2])
Parameters:
number1
: The first numeric value to compare.number2
: [Optional] The second numeric value to compare.
Step-by-Step Tutorial
-
Using
DELTA
with two numbers:- Example:
=DELTA(5, 5)
- Result:
1
- Example:
-
Using
DELTA
with only one number:- Example:
=DELTA(8)
- Result:
0
- Example:
Use Cases and Scenarios
- Equality Comparison: Check if two numbers are equal.
- Conditional Formulas: Use
DELTA
in conditional formulas to perform specific actions based on equality.
Related Functions
- None
Related Articles
- None