About HEX2DEC() function
The HEX2DEC() function is an Engineering function that converts a hexadecimal number into decimal number. It keeps a single argument that is number.
Where to apply :
This function is used by engineers where machines need to convert the hexadecimal number into decimal number. It is also used in education.
number- A hexadecimal number.
1. For the hexadecimal number is E.
=HEX2DEC(E) // Returns (14)
It returns 14 for the hexadecimal number E.
Excel based example:
The HEX2DEC() function is well explained in above image.
Hope, it would have added in your Excel function knowledge.
Best Excel training institute in Noida provides Basic Excel, Advance Excel and VBA offline and online classes.
If you want to learn Excel & VBA courses to be Excel expert, connect us on:
9599408486 / 8929231250