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.