<< Go back to all functions

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

  1. Using DELTA with two numbers:

    • Example: =DELTA(5, 5)
    • Result: 1
  2. Using DELTA with only one number:

    • Example: =DELTA(8)
    • Result: 0

Use Cases and Scenarios

  1. Equality Comparison: Check if two numbers are equal.
  2. Conditional Formulas: Use DELTA in conditional formulas to perform specific actions based on equality.

Related Functions

  • None

Related Articles

  • None