Engineering functions

The following functions are useful for manipulating binary digits.

Functions Returns
BITAND function Bitwise 'AND' of two binary numbers.
BITLSHIFT function Binary number shifted left based on a given number of bits.
BITOR function Bitwise 'OR' of two numbers.
BITRSHIFT function Calculates the number where the binary equivalent is shifted right by a specified number of bits and then converted back to a number.
BITXOR function Calculates a decimal number that is a result of a bitwise comparison "XOR" of two numbers.

The following functions convert values between different numeral systems.

Functions Returns
BIN2DEC function Converts a binary number to the decimal number system.
BIN2HEX function Converts a binary number to hexadecimal.
BIN2OCT function Converts a binary number to octal.
CONVERT function Converts a number from one measurement system to another.
DEC2BIN function Converts a decimal number to a binary number.
DEC2HEX function Converts a decimal number to a hexadecimal number.
DEC2OCT function Converts a decimal number to an octal number.
Numeral system Base
Binary 2
Octal 8
Decimal 10
Hexadecimal 16

The following functions are useful for performing calculations to imaginary numbers.

Functions Returns
COMPLEX function Returns a complex number based on a real and imaginary number.

Miscellaneous functions in category Engineering.

Functions Returns
DELTA function Evaluates whether two numerical values are equal.

How to use the DELTA function

The DELTA function evaluates whether two numerical values are equal. This function is also known as the¬†Kronecker Delta function, read […]

How to use the BITXOR function

The BITXOR function calculates a decimal number that is a result of a bitwise comparison "XOR" of two numbers. XOR […]

How to use the BITRSHIFT function

The BITRSHIFT function calculates the number where the binary equivalent is shifted right by a specified number of bits and […]

How to use the BITOR function

The BITOR function performs a bitwise 'OR' of two numbers. Bitwise meaning each digit in the binary equivalent. Formula in […]

How to use the BITLSHIFT function

The BITLSHIFT function calculates a number whose binary representation is shifted left by a specified number of bits. Formula in […]

How to use the BITAND function

The BITAND function calculates a bitwise 'AND' of two numbers. The function performs AND logic bit by¬†bit on the numbers […]

How to use the BIN2OCT function

The BIN2OCT function converts a binary number to octal. Formula in cell B3: =BIN2OCT(11001) Excel Function Syntax BIN2OCT(number,[places]) Arguments number […]

How to use the BIN2HEX function

The BIN2HEX function converts a binary number to hexadecimal. Formula in cell B3: =BIN2HEX(11001) Excel Function Syntax BIN2HEX(number,[places]) Arguments number […]

How to use the BIN2DEC function

The BIN2DEC function converts a binary number to decimal. Formula in cell B3: =BIN2DEC(11001) Excel Function Syntax BIN2DEC(number) Arguments number […]

How to use the DEC2OCT function

The DEC2OCT function converts a decimal number to an octal number. Formula in cell D3: =DEC2OCT(B3,C3) Excel Function Syntax DEC2OCT(number, […]

How to use the DEC2HEX function

The DEC2HEX function converts a decimal number to a hexadecimal number. Formula in cell D3: =DEC2HEX(B3,C3) Excel Function Syntax DEC2HEX(number, […]

How to use the DEC2BIN function

The DEC2BIN function converts a decimal number to a binary number. Formula in cell D3: =DEC2BIN(B3,C3) Excel Function Syntax DEC2BIN(number, […]

How to use the CONVERT function

The CONVERT function converts a number from one measurement system to another. Formula in cell E3: =CONVERT(B3, C3, D3) The […]

How to use the COMPLEX function

The COMPLEX function returns a complex number based on a real and imaginary number. Formula in cell B3: =COMPLEX(2,3) Excel […]