Syntax
=HEX2DEC(number)Arguments
| Argument | Required | Description |
|---|---|---|
number | Required | The hexadecimal number (up to 10 characters) |
How to use HEX2DEC
HEX2DEC takes 1 required argument. Type =HEX2DEC( in a cell and SheetsBat shows the arguments as you go. Optional arguments are shown in square brackets; leave them out to use their default.
Examples
Each result below was calculated by the SheetsBat formula engine.
=HEX2DEC("A5")Result =HEX2DEC("FFFFFFFF5B")Result =HEX2DEC("3DA408B9")Result Related engineering functions
- ERFCReturns the complementary error function integrated between a value and infinity.
- ERFC.PRECISEReturns the complementary error function integrated between a value and infinity.
- GESTEPReturns 1 when a number is greater than or equal to a step value and 0 otherwise.
- HEX2BINConverts a hexadecimal number to binary.
- HEX2OCTConverts a hexadecimal number to octal.
- IMABSReturns the absolute value (modulus) of a complex number.
- IMAGINARYReturns the imaginary part of a complex number.
- IMARGUMENTReturns the angle (argument) of a complex number, in radians.
- IMCONJUGATEReturns the complex conjugate of a complex number.