Spread Formula Reference
OCT2BIN
Formula Functions > Functions M to Q > OCT2BIN

This function converts an octal number to a binary number.

Syntax

OCT2BIN(number,places)

Arguments

This function has these arguments:

Argument Description
number Octal numeric value to convert, must be 10 characters or less, and must be between 7777777000 and 777
places [Optional] Number of characters to return; if not an integer, the number is truncated

Remarks

An error value is returned if the number is invalid or if places is non-numeric or negative. If places is omitted, the calculation uses the minimum number of characters necessary. This argument is useful for adding leading zeros to the result.

Data Types

Accepts numeric data. Returns numeric data.

Examples

OCT2BIN(77770000)

Version Available

This function is available in product version 2.0 or later.

See Also

OCT2DEC | OCT2HEX | HEX2BIN | DEC2BIN | Engineering Functions