:Binary to hexadecimal: BIN2HEX function usage guide-Table skills免费ppt模版下载-道格办公

The following is the rewritten content, retaining the HTML tags and image address information: ```html

Picture and text skills
Case

Convert binary number to hexadecimal number.

Grammar

BIN2HEX(number, places)

￭ Number The binary number to be converted. Number cannot have more than 10 digits (binary digits), the highest bit is the sign bit, and the remaining 9 bits are numeric bits.

Negative numbers are represented using two's complement notation.

￭ Places Number of characters to use. If places is omitted, the function DEC2BIN uses the fewest characters that can represent the number.

places is particularly useful when you need to prepend leading zeros to the returned value.

Description

￭ If the number is an illegal binary number or has more than 10 digits, BINZHEX returns the error value #NUM!.

￭ If the number is negative, BINZHEX ignores places and returns a ten-character hexadecimal number.

￭ If BINZHEX requires more digits than specified by places, it returns the #NUM! error value.

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

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

￭ If places is a negative value, BINZHEX 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/er-jin-zhi-zhuan-shi-liu-jin-zhi-BIN2HEX-han-shu-shi-yong-zhi-nan.html