| Syntax |
| =DELTA(number1,[number2]) |
| Purpose / Description |
| Compares two numbers and returns 1 if they are exactly the same, and 0 if they are different. |
| Arguments |
| Name |
Type |
Description |
| number1 |
number |
A constant, reference or nested expression that returns a value to be compared. If the value is a numeric text string, it is coerced to a number. |
| [number2] |
number |
An optional constant, reference or nested expression that returns a second value to be compared to the first. If the value is a numeric text string, it is coerced to a number. Defaults to 0 if it is omitted. |
| Return Values |
| Type |
Specific Value |
Description |
| number |
1 |
Both numbers are the same (after any coercion of numeric text strings required). If the number2 argument is omitted, it indicates that the value of number1 is 0. |
| number |
|
The numbers are not the same If the number2 argument is omitted, it indicates that the value of number1 is non-zero. |
| error |
#VALUE! |
Either the value passed to number1 or number2 is a non-numeric text string or is a logical value. |
| error |
|
Any errors referenced by arguments are returned due to propagation of error values. |
| Notes / Comments / Advice / Warnings |
| Note: |
Only compares numeric values. |
| Comment: |
Can be useful in dynamic arrays and filtering formulas. |
| Examples: |
Open / download sample workbook: DELTA.xlsx |
| |