DELTA Function in Google Sheets

Check if two numbers are equal using the DELTA function.

DELTA Function

The DELTA function in Google Sheets is used to check whether two numbers are equal. It returns 1 if they are equal, and 0 otherwise.

Syntax

DELTA(number1, [number2])
  • number1: The first number to compare. This is a required parameter.
  • number2: (Optional) The second number to compare. If omitted, it defaults to 0.

Examples

  1. Comparing Two Numbers

Compare the numbers 5 and 5:

=DELTA(5, 5)

This will output 1, indicating the numbers are equal.

  1. Comparing Two Different Numbers

Compare the numbers 5 and 3:

=DELTA(5, 3)

This will output 0, indicating the numbers are not equal.

  1. Default Comparison with 0

Compare the number 2 with 0:

=DELTA(2)

This will output 0.

Notes

  • The DELTA function is useful in logical operations where numerical equality needs to be tested.
  • It can handle both integers and decimal numbers.
  • EQ: Compare two numbers and return TRUE if they are equal.
  • IF: Perform logical tests and return different values based on the test results.