About DEC2HEX() function
The DEC2HEX() function is an Engineering function that converts a decimal number into hexadecimal number. It keeps a single argument that is number.
Where to apply :
This function is used by engineers where machines need to convert the decimal number into hexadecimal number. It is also used in education.
number- A decimal number. it means positive and negative numbers.
1. For the decimal number is 15.
=DEC2HEX(15) // Returns (F)
It returns F for the decimal number 15.
Excel based example:
The DEC2HEX() 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