:HEX2BIN function converts hexadecimal to binary-Table skills免费ppt模版下载-道格办公

Picture and text skills
Case

Convert hexadecimal number to binary number.

Syntax
HEX2BIN (number,places)
Number to be converted Hexadecimal number. The number of parameters cannot exceed 10 digits, the highest bit is the sign bit (the 40th binary digit from the right), and the rest

Bit 39 is the digital bit. Negative numbers are represented by the binary number's complement.

Places The number of characters to use. If places is omitted, the HEX2BIN function uses the fewest characters that can represent the number. When it is necessary to return the number

places is especially useful when the value has leading zeros.

Description

￭ If the parameter number is a negative number, HEX2BIN will ignore places and return a 10-digit binary number.

￭ If the parameter number is a negative number, it cannot be less than FFFFFFFE00; if the parameter number is a positive number, it cannot be greater than 1FF.

￭ If the parameter Number is not a legal hexadecimal number, HEX2BIN returns the error value #NUM!.

￭ If HEX2BIN requires more digits than places specified, the error value #NUM! will be returned.

￭ If places is not an integer, it will be truncated.

￭ If places is non-numeric, HEX2BIN returns the error value #VALUE!.

￭ If places is a negative value, HEX2BIN returns the error value #NUM!.

Articles are uploaded by users and are for non-commercial browsing only. Posted by: Lomu, please indicate the source: https://www.daogebangong.com/en/articles/detail/HEX2BIN-han-shu-shi-liu-jin-zhi-zhuan-huan-cheng-er-jin-zhi.html