## 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

- Click on an
**empty cell**(like F5).

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

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

4. Select the **Engineering **category.

5. Select the **BIN2OCT **function.

6. Then select **ok**.

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

**BIN2OCT**

It Converts a **binary **number to an **octal**.

## Return value of **BIN2OCT** function

**BIN2OCT**

It returns a number.

## Arguments of **BIN2OCT** function

**BIN2OCT**

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

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

## Errors in **BIN2OCT** function

**BIN2OCT**