Calc OCT2BIN function

For a full list of available calculation functions, please read What calculation functions are supported.

This article describes the formula syntax and usage of the OCT2BIN function.

Description

Converts an octal number to binary.

Syntax

OCT2BIN(number, [places])

• number - Required. The octal number you want to convert. The number cannot contain more than 10 characters (the most significant bit is the sign bit).
• places - Optional. The number of characters to use. If places is omitted, the minimum number of characters necessary to represent the binary number is used. If places is specified and is greater than the length of the converted binary number, the result is padded with leading zeros. If places is specified and is less than the length of the converted binary number, the #NUM! error value is returned.

Remarks

• Number is interpreted as a signed number in octal notation. Valid numbers are from 0 to 7777777777 (octal), which is equivalent to 0 to 536870911 (decimal) for positive numbers, and from -1 to -2000000000 (octal), which is equivalent to -1 to -536870912 (decimal) for negative numbers.
• If number is not a valid octal number, OCT2BIN returns the #NUM! error value.
• If number is negative, OCT2BIN uses two's-complement notation to represent the binary number.

Example

Errors

For a full list of formula errors, please read Formula errors.

Related functions

• Calc BIN2DEC function
• Calc BIN2HEX function
• Calc BIN2OCT function
• Calc CONVERT function
• Calc DEC2BIN function