# DELTA

## Content

This function identifies whether two values are equal. Returns 1 if they are equal; returns 0 otherwise.

## Syntax

`DELTA(value1, [value2])`

## Arguments

<span data-teams="true">This function has these arguments:</span>

| <span data-teams="true">Argument</span> | <span data-teams="true">Description</span> |
| -------- | ----------- |
| *<span data-teams="true">value1</span>* | <span data-teams="true"> [Required] First numeric value to compare</span> |
| *<span data-teams="true">value2</span>* | <span data-teams="true"> [Optional] Second numeric value to compare. If omitted, defaults to 0</span> |

## Remarks

Also called the Kronecker Delta function. This is a discrete version of the Dirac delta function.

## Examples

`DELTA(A1,5)`
`DELTA(R1C4,R2C5)`
`DELTA(3,3)` gives the result 1
`DELTA(3,2)` gives the result 0
`DELTA(3,2.99999)` gives the result 0
`DELTA(3,QUOTIENT(6,2))` gives the result 1