WPS Table Engineering function

1. Bin2dec
Purpose: Converts a binary number to a decimal number.
Syntax: Bin2dec (binary number)
Parameter: The number of digits in the binary number cannot be more than 10 bits (bits), the highest bit is the symbol bit, and the latter 9 digits are digits. Negative numbers are expressed in binary number complement.
2. Bin2Hex
Purpose: Converts a binary number to a hexadecimal number.
Syntax: Bin2Hex (binary number, number of characters)
Parameter: The number of digits in the binary number cannot be more than 10 bits (bits), the highest bit is the symbol bit, and the latter 9 digits are digits. Negative numbers are represented by the binary number complement; If the number of characters is omitted, the function dec2bin is represented by the fewest characters that can represent the number.
3. CONVERT
Purpose: Converts a number from one metric system to another.
Syntax: CONVERT (number, initial unit, result unit)
Parameters: Numeric values are values that need to be converted in units of initial units. The initial unit is the unit of the numeric value.
4. Dec2bin
Purpose: Converts a decimal number to a binary number.
Syntax: Dec2bin (decimal number, number of characters)
Parameters: If the number of characters is omitted, the function dec2oct is represented by the fewest characters that can represent this number.
5. Dec2hex
Purpose: Converts a decimal number to a hexadecimal number.
Syntax: Dec2hex (decimal number, number of characters)
Parameters: Ditto.
6. Hex2bin
Purpose: Converts a hexadecimal number to a binary number.
Syntax: Hex2bin (hexadecimal number, number of characters)
7. Hex2dec
Purpose: Converts a hexadecimal number to a decimal number.
Syntax: Hex2dec (hexadecimal number)
Parameter: The number of digits in the hexadecimal number of the parameter cannot be more than 10 bits (40-bit binary), the highest bit is the symbol bit, and the remaining 39 digits are digit digits. Negative numbers are represented by the complement of binary numbers.