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 BITXOR function
What is the BITXOR function? The BITXOR function calculates a decimal number that is a result of a bitwise comparison […]
How to use the BITRSHIFT function
What is the BITRSHIFT function? The BITRSHIFT function calculates a number based on the decimal system whose binary representation is […]
What is the BITOR function? The BITOR function performs a bit-wise 'OR' of two decimal numbers, it returns a decimal […]
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 […]
How to use the BIN2OCT function
The BIN2OCT function converts a binary number to octal. What is the binary system? The binary system is a positional […]
How to use the BIN2HEX function
What is the BIN2HEX function? The BIN2HEX function converts a binary number to a hexadecimal number. Table of Contents Introduction […]
How to use the BIN2DEC function
The BIN2DEC function converts a binary number to decimal. What is a binary number? The binary system is a positional […]
How to use the CONVERT function
The CONVERT function converts a number from one measurement system to another. It lets you perform conversions in these categories: […]