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. |
What is the IMTAN function? The IMTAN function calculates the tangent of a complex number in x + yi or […]
The IMSUM function calculates the total of two or more complex numbers in x + yi or x + yj […]
What is the IMSUB function? The IMSUB function calculates the difference between two complex numbers in x + yi or […]
How to use the IMSQRT function
The IMSQRT function calculates the square root of a complex number in x + yi or x + yj text […]
How to use the IMSINH function
What is the IMSINH function? The IMSINH function calculates the hyperbolic sine of a complex number in x + yi […]
What is the IMSIN function? The IMSIN function calculates the sine of a complex number in x + yi or […]
How to use the IMSECH function
What is the IMSINH function? The IMSECH function calculates the hyperbolic secant of a complex number in x + yi […]
What is the IMSEC function? The IMSEC function calculates the secant of a complex number in x + yi or […]
How to use the IMREAL function
The IMREAL function calculates the real coefficient of a complex number in x + yi or x + yj text […]
How to use the IMPRODUCT function
The IMPRODUCT function calculates the product of complex numbers in x + yi or x + yj text format. The […]
How to use the IMPOWER function
The IMPOWER function calculates a complex number raised to a given power in x + yi or x + yj […]
How to use the IMLOG2 function
The IMLOG2 function calculates the base 2 logarithm of a complex number in x + yi or x + yj […]
How to use the IMLOG10 function
The IMLOG10 function calculates the base 10 logarithm (common logarithm) of a complex number in x + yi or x […]
The IMLN function calculates the natural logarithm of a complex number in x + yi or x + yj text […]
The IMEXP function calculates the exponential of a complex number in x + yi or x + yj text format. […]
The IMDIV function calculates the quotient of two complex numbers in x + yi or x + yj text format. […]
How to use the IMCSCH function
What is the IMCSCH function? The IMCSCH function calculates the hyperbolic cosecant of a complex number in x + yi […]
The IMCSC function calculates the cosecant of a complex number in x + yi or x + yj text format. […]
The IMCOT function calculates the cotangent of a complex number in x + yi or x + yj text format. […]
How to use the IMCOSH function
What is the IMCOSH function? The IMCOSH function calculates the hyperbolic cosine of a complex number in x + yi […]
What is the IMCOS function? The IMCOS function calculates the cosine of a complex number in x + yi or […]
How to use the IMCONJUGATE function
The IMCONJUGATE function calculates the complex conjugate of a complex number in x + yi or x + yj text […]
How to use the IMARGUMENT function
The IMARGUMENT function calculates the argument theta θ which is an angle displayed in radians based on complex numbers in […]
How to use the BITLSHIFT function
What is the BITLSHIFT function? The BITLSHIFT function calculates a decimal number whose binary representation is shifted left by a […]
How to use the BITAND function
What is the BITAND function? The BITAND function calculates a bitwise 'AND' of two decimal numbers. Note, it also returns […]