I. Intro
The BIN2OCT function converts a binary number to an octal number.
II. About the function
- Formula: =BIN2OCT(binary_number,[places])
- Parameters:
- binary_number (required): The binary value (up to 10 characters) that you want to convert to an octal number (string representation).
- places (optional): The number of significant figures to return.
- Example: =BIN2OCT(101,8)
- Note:
- If the number is not a binary value, or it contains more than 10 characters (10 "places"), then BIN2OCT returns the error value #NUM!.
- If the number is negative, then BIN2OCT ignores "places" and returns an octal value with 10 characters.
- If BIN2OCT requires more characters than specified by "places", it returns the error value #NUM!.
- If "places" is not an integer, it is rounded up or down.
- If "places" is not a value, then BIN2OCT returns the error value #VALUE!.
- If "places" is negative, then BIN2OCT returns the error value #NUM!.
III. Steps
Use the BIN2OCT function
- Select a cell and click Formulas on the toolbar, then select Engineering > BIN2OCT. You can also directly enter =BIN2OCT in a cell.
- Enter the parameters in the cell. For example: =BIN2OCT(A3).
- Press Enter for the result, which is 0 in this example.
250px|700px|reset
Delete the BIN2OCT function
Select the cell with the BIN2OCT function, and press Delete.