Hexa2Dec Formula
|
|
Hexadecimal
|
Decimal Number
|
|
|
|
0
|
0
|
=HEX2DEC(C4)
|
|
|
1
|
1
|
=HEX2DEC(C5)
|
|
|
2
|
2
|
=HEX2DEC(C6)
|
|
|
3
|
3
|
=HEX2DEC(C7)
|
|
|
1A
|
26
|
=HEX2DEC(C8)
|
|
|
1B
|
27
|
=HEX2DEC(C9)
|
|
|
7FFFFFFFFF
|
549,755,813,887
|
=HEX2DEC(C10)
|
|
|
8000000000
|
-549,755,813,888
|
=HEX2DEC(C11)
|
|
|
FFFFFFFFFF
|
-1
|
=HEX2DEC(C12)
|
|
|
FFFFFFFFFE
|
-2
|
=HEX2DEC(C13)
|
|
|
FFFFFFFFFD
|
-3
|
=HEX2DEC(C14)
|
|
|
|
|
|
|
What Does It Do ?
|
|
|
|
|
This function
converts a hexadecimal number to its decimal equivalent.
|
|||
|
|
|
|
|
|
Syntax
|
|
|
|
|
=HEX2DEC(HexaDecimalNumber)
|
|
||
|
|
|
|
|
|
Formatting
|
|
|
|
|
No
special formatting is needed.
|
|
||
|
|
|
|
|
|
Example
|
|
|
|
|
The following
table was used to add two hexadecimal values together.
|
|||
|
|
|
|
|
|
|
Hexadecimal
|
|
|
|
Value 1
|
F
|
|
|
|
Value 2
|
1A
|
|
|
|
Result
|
29
|
=DEC2HEX(HEX2DEC(C29)+HEX2DEC(C30))
|
|