## What is BASE function in Excel?

The **Base** function is one of the math functions of Excel.

It Converts a **number into a text **representation with a given radix(base).

We can find this function in **Math & trig** category of insert function Tab.

## How to use Base 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 **math and trig** category

5. Select **BASE** function

6. Then select **ok**

7. In the function arguments Tab you will see **BASE** function

8. In the **number box** you must enter **one** number (for example 56)

9. Radix is the **base number** you want to **convert into** (for example 10)

10. Min_length is the **minimum length** of the returned **string. if you want to **add zero to begin of the string put a value **more than 3**

11. If you enter values**(56,10,3)** result will be **056**, As shown below:

12. If you enter values**(12,2,0)** result will be **1100**, As shown below:

13. If you enter values**(12,2,5)** result will be** 01100**, As shown below:

14. You will see **results **in the formula result section

### Things to Remember

- The argument of this function is
**number** - The argument of this function is
**required and not optional** - This function is available for all
**excel versions**(2007-2019)

## Examples of **BASE** function in Excel

**Example 1:**

**How to use BASE function in excel**

You can see examples of BASE function below:

**base**(A2,B2,C2) ----->>>>answer is 056
**base**(A3,B3,C3) ----->>>>answer is 1100
**base**(A4,B4,C4) ----->>>>answer is 01100
**base**(A5,B5,C5) ----->>>>answer is 000121
**base**(A6,B6,C6) ----->>>>answer is 0236

## What is the purpose of **BASE** function?

**BASE**

It Converts a **number into a text **representation with a given radix(base).

## What is the Return value of **BASE** function?

**BASE**

It returns a number.

## How many arguments does **BASE** function have?

**BASE**

This function has just **1** Argument.

The **argument **of BASE function is **number**.

In the **number box** you must enter **one** number (for example 56).

Radix is the **base number** you want to **convert into** (for example 10).

Min_length is the **minimum length** of the returned **string. if you want to **add zero to begin of the string put a value **more than 3**.

The argument of BASE function is **required **and not optional.

```
BASE(number) = number
```

## Which version of excel supports **BASE** function?

**BASE**

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

## Errors in **BASE** function

**BASE**