- Picture and text skills
- Case
Convert a binary number to a 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 The number of characters to use. If places is omitted, the function DEC2BIN uses the fewest characters that can represent the number.
places are especially 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 hexadecimal number represented by ten characters.
￭ If BINZHEX requires more digits than places specifies, the #NUM! error value will be returned.
￭ 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/BIN2HEX-han-shu-er-jin-zhi-zhuan-huan-cheng-shi-liu-jin-zhi.html
支付宝扫一扫 
评论列表（196条）
测试