Use Of HEX2DEC
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
|
5,49,75,58,13,887
|
=HEX2DEC(C10)
|
8000000000
|
-5,49,75,58,13,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))
|
कोई टिप्पणी नहीं:
एक टिप्पणी भेजें