- Picture and text skills
- Case
Convert a binary number to octal.
Grammar
BIN2OCT(number, [places])
BIN2OCT function syntax has the following parameters:
Number Required. The binary number to convert. Number cannot contain more than 10 characters (10 digits).
The highest bit of Number is the sign bit. The remaining 9 digits are quantity digits. Negative numbers are represented in two's complement notation.
Places are optional. The number of characters to use. If places is omitted, BIN2OCT uses the minimum number of characters required.
Places can be used to prepend 0 (zero) to the returned value.
Description
■If Number is an illegal binary number, or it contains more than 10 characters (10 bits), BIN2OCT returns the #NUM! error value.
■If the number is negative, BIN2OCT ignores Places and returns a ten-character octal number.
■If BIN2OCT requires more characters than places specifies, a #NUM! error value will be returned.
■If places is not an integer, it will be truncated.
■If places is non-numeric, BIN2OCT returns a #VALUE! error value.
■If places is a negative value, BIN2OCT returns a #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/BIN2OCT-han-shu-er-jin-zhi-zhuan-ba-jin-zhi-shu.html
评论列表(196条)
测试