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
DELTAwith two numbers:- Example:
=DELTA(5, 5) - Result:
1
- Example:
-
Using
DELTAwith only one number:- Example:
=DELTA(8) - Result:
0
- Example:
Use Cases and Scenarios
- Equality Comparison: Check if two numbers are equal.
- Conditional Formulas: Use
DELTAin conditional formulas to perform specific actions based on equality.
Related Functions
- None
Related Articles
- None