Help Centre › Functions & Formulas
For a full list of available calculation functions, please read What calculation functions are supported.
Description
The HEX2DEC function converts a hexadecimal number to its decimal equivalent. This is useful in various applications, especially in computing and digital electronics, where hexadecimal representation is commonly used.
Syntax
HEX2DEC(number)
The HEX2DEC function syntax has the following arguments:
- number Required. The hexadecimal number you want to convert to decimal. It must be a valid hexadecimal string.
Example
| Formula | Description | Result |
| =HEX2DEC("A") | Converts the hexadecimal number "A" to decimal. | 10 |
| =HEX2DEC("FF") | Converts the hexadecimal number "FF" to decimal. | 255 |
| =HEX2DEC("-1") | Converts the hexadecimal number "-1" to decimal (two's complement representation). | -1 |
Errors
For a full list of formula errors, please read Formula errors.