# 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" style="margin: 0px; padding: 0px; -webkit-font-smoothing: antialiased; box-sizing: border-box;">This function has these arguments:</span>

| <span data-teams="true" style="margin: 0px; padding: 0px; -webkit-font-smoothing: antialiased; box-sizing: border-box;">Argument</span> | <span data-teams="true" style="margin: 0px; padding: 0px; -webkit-font-smoothing: antialiased; box-sizing: border-box;">Description</span> |
| -------- | ----------- |
| *<span data-teams="true" style="margin: 0px; padding: 0px; -webkit-font-smoothing: antialiased; box-sizing: border-box;">value1</span>* | <span data-teams="true" style="margin: 0px; padding: 0px; -webkit-font-smoothing: antialiased; box-sizing: border-box;"> [Required] First numeric value to compare</span> |
| *<span data-teams="true" style="margin: 0px; padding: 0px; -webkit-font-smoothing: antialiased; box-sizing: border-box;">value2</span>* | <span data-teams="true" style="margin: 0px; padding: 0px; -webkit-font-smoothing: antialiased; box-sizing: border-box;"> [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

<br>