Purpose
Return value
Syntax
=DELTA(number1,[number2])
- number1 - The first number.
- number2 - [optional] The second number.
Using the DELTA function
The DELTA function tests two numeric values for equality. When values are equal, DELTA returns 1. When values are different, DELTA returns zero. As a result, DELTA can be used to easily count pairs of equal numbers.
For example:
=DELTA(5,4) // returns 0
=DELTA(3,3) // returns 1
In the example shown, the formula in D6, copied down, is:
=DELTA(B6,C6)
Notes:
- If number2 is left blank, DELTA assumes number2 equals zero
- If either value is text, DELTA returns the #VALUE error.
Purpose
Return value
Syntax
=HEX2BIN(number,[places])
- number - The hexadecimal number you want to convert to binary.
- places - [optional] Pads the resulting binary number with zeros up to the specified number of digits. If omitted returns the least number of characters required to represent the number.
Using the HEX2BIN function
- Excel only converts to binary numbers of 10-digits or less, restricting the input range to [-512, 511] (decimal).
- The input number must be less than or equal to ten alpha-numeric characters, otherwise the function returns the #NUM! error value.
- The internal (binary) representation of the hexadecimal number uses two’s complement notation. The first bit indicates whether the number is positive or negative, and the other 39 bits indicate the magnitude of the number.
