HEX2DEC Function (Functions in Excel)
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)) |
0 comments:
Post a Comment