Excel BIN2OCT Function

What is BIN2OCT function in Excel?


The BIN2OCT function is one of the Engineering functions of Excel.

It Converts a binary number to an octal.

We can find this function in ENGINEERING of insert function Tab.

How to use BIN2OCT function in excel

  1. Click on an empty cell (like F5).
empty cell in excel

2. Click on the fx icon (or press shift+F3).

fx icon in excel

3. In the insert function tab you will see all functions.

insert function tab

4. Select the Engineering category.

5. Select the BIN2OCT function.

6. Then select ok.

excel BIN2OCT function

7. In the function arguments Tab you will see BIN2OCT function.

8. Number section is the binary number you want to convert.

9. Places section is the number of characters to use.

10. You will see the results in the formula result section.

Examples of BIN2OCT function in Excel

Example 1:

How to use BIN2OCT function in excel

You can see examples of BIN2OCT function below:

bin2oct(A2) ----->>>>answer is  177

bin2oct(A3) ----->>>>answer is  134

bin2oct(A4) ----->>>>answer is  117

bin2oct(A5) ----->>>>answer is  7777777001

bin2oct(A6) ----->>>>answer is  477

Purpose of BIN2OCT function

It Converts a binary number to an octal.

Return value of BIN2OCT function

It returns a number.

Arguments of BIN2OCT function

This function has just 2 Argument.

The argument of BIN2OCT function is number.

Number section is the binary number you want to convert.

Places section is the number of characters to use.

The argument of BIN2OCT function is required and not optional.

BIN2OCT(number) = number

Version of excel supports BIN2OCT function

This function is available for all excel versions (2003-2019)

Errors in BIN2OCT function

BIN2OCT related functions 

Leave a Reply

Your email address will not be published. Required fields are marked *