Showing posts sorted by date for query HEX2DEC. Sort by relevance Show all posts
Showing posts sorted by date for query HEX2DEC. Sort by relevance Show all posts

HEX2DEC Function

August 15, 2018 0
how to use dec2hex function in excel


You can convert Hexadecimal numbers into decimal numbers
The hexadecimal numbers contain only 0 and F values


HEX2DEC Function has a limit of nine times "f" decimal numbers
If you write more than ten times "F" characters it will return"-1"
If you write more than ten times"F" it will return #NUM error

Syntax


=DEC2HEX(number)

Argument

Number: it is the number you want to convert into hexadecimal

Behavior





Here we have taken an example of the hexadecimal number and convert it into decimal numbers.
We have written a formula  

=HEX2DEC(D4) which will convert the hexadecimal number into decimal

On the right side, if you write nine times "F" it will return "68719476735"
if you write ten times "F" it will return "-1"
If you write more then ten times "F" it will return #NUM error

Usage

To convert a Hexadecimal number into a Decimal number

Returns

Decimal number

Engineering Functions

August 01, 2018 0
how to use engineering functions


You can solve your engineering problem by using simple Excel formulas and functions

Number System Conversion

BIN2DEC    Converts Binary number system to Decimal number system
BIN2HEX    Converts Binary number system to Hexa Decimal number system
BIN2OCT    Converts Binary number system to Octal number system
DEC2BIN    Converts Decimal number system to Binary number system
DEC2HEX   Converts Decimal number system to Hexa Decimal number system
DEC2OCT   Converts Decimal number system to Octal number system
OCT2BIN    Converts Octal number system to Binary number system
OCT2DEC   Converts Octal number system to Decimal number system
OCT2HEX   Converts Octal number system to Hexa Decimal number system
HEX2BIN    Converts Hexa Decimal number system to Binary number system
HEX2OCT   Converts Hexa Decimal number system to Octal number system
HEX2DEC   Converts Hexa Decimal number system to Decimal number system

Bit Wise Operations
BITAND         Bitwise AND Operation
BITOR            Bitwise OR operation
BITXOR         Bitwise Exclusive OR Operation
BITLSHIFT    Bitwise Shift LEFT Operation
BITRSHIFT    Bitwise Shift RIGHT Operation

CONVERT     Converts one unit to another unit