- Picture and text skills
- Case
Convert a decimal number to a binary number.
Syntax
DEC2BIN(number,places)
Number The decimal number to be converted. If the parameter number is negative, places is omitted.
Function DEC2BIN returns a 10-bit binary number, the highest bit is the sign bit, and the remaining 9 bits are numeric bits. Negative numbers are represented by the binary number's complement.
Places The number of characters to be used. 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 number
￭If the parameter number is non-numeric, DEC2BIN returns the error value #VALUE!.
￭If the function DEC2BIN 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, DEC2BIN returns the error value #VALUE!.
￭If places is a negative value, DEC2BIN returns the #NUM! error value.
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/DEC2BIN-han-shu-jiang-shi-jin-zhi-zhuan-huan-er-jin-zhi-shu.html
支付宝扫一扫 
评论列表（196条）
测试