Calc BIN2OCT 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 BIN2OCT function.

Description

Converts a binary number to octal.

Syntax

BIN2OCT(number, [places])

• number - Required. The binary number you want to convert to octal. The number can be a text string or a number.
• [places] - Optional. The number of characters to use. If the result has fewer characters than places, BIN2OCT adds leading zeros to the result until it reaches the specified length.

Remarks

• If the number is not a valid binary number, BIN2OCT returns the #NUM! error value.
• If the number is larger than 511, BIN2OCT returns the #NUM! error value.
• If the number is less than -512, BIN2OCT returns the #NUM! error value.

Example

Errors

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

Related functions

• Calc BIN2DEC function
• Calc BIN2HEX function
• Calc CONVERT function
• Calc DEC2BIN function
• Calc DEC2HEX function