How to use the BIN2OCT function
Author: Oscar Cronquist Article last updated on May 11, 2022
The BIN2OCT function converts a binary number to octal.
Formula in cell B3:
=BIN2OCT(11001)
Excel Function Syntax
BIN2OCT(number,[places])
Arguments
| number | Required. The binary number you want to convert to octal. |
| [places] | Optional. The number of characters to use. If not entered the minimum number of characters is used. Use this argument to add leading 0 (zeros). |
Comments
Maximum binary values are 10 characters.
Functions in 'Engineering' category
The BIN2OCT function function is one of many functions in the 'Engineering' category.
Converts a binary number to the decimal number system.
Converts a binary number to hexadecimal.
Converts a binary number to octal.
Calculates a bitwise 'AND' of two numbers.
Calculates a number whose binary representation is shifted left by a specified number of bits.
Performs a bitwise 'OR' of two numbers.
Calculates the number where the binary equivalent is shifted right by a specified number of bits and then converted back to a number.
Calculates a decimal number that is a result of a bitwise comparison "XOR" of two numbers.
Returns a complex number based on a real and imaginary number.
Converts a number from one measurement system to another.
Converts a decimal number to a binary number.
Converts a decimal number to a hexadecimal number.
Converts a decimal number to an octal number.
Evaluates whether two numerical values are equal.
How to comment
How to add a formula to your comment
<code>Insert your formula here.</code>
Convert less than and larger than signs
Use html character entities instead of less than and larger than signs.
< becomes < and > becomes >
How to add VBA code to your comment
[vb 1="vbnet" language=","]
Put your VBA code here.
[/vb]
How to add a picture to your comment:
Upload picture to postimage.org or imgur
Paste image link to your comment.
Contact Oscar
You can contact me through this contact form