Microsoft Excel provides plenty of built-in functions and formulas for performing mathematical calculations. The base function in Excel is used to **display the base value of a number** as a **numerical or text** representation according to the given radix or base. If you want to get the text value of the integer based on a specific radix, we suggest you use the BASE function.

This tutorial will guide you to learn how to use **Excel BASE Function** with its syntax, description, and examples. Get an official version of** **MS **Excel** from the following link:

https://www.microsoft.com/en-in/microsoft-365/excel

## Jump To

## What is the BASE Function?

BASE is one of the **built-in functions** in Microsoft Excel. It comes under **Math **functions. We can use this function in our spreadsheet whenever we want to **convert a number into a text representation of a given radix** or base.

### 1) Syntax

- This is the basic syntax of the Excel BASE Function.
- You can
**apply this formula**in any cell where you want to get the result. **Hit**the**Enter**button.

**=BASE(number, radix, [min_length])**

### 2) Arguments

**Number –**The input number to convert to a given base. It must be an integer value that is greater than or**equal to 0**and**less than****2ˆ53**.**Radix****–**It represents the base to convert to. It must be an integer**greater than or equal to 2 less than**or**equal to 36**.**Min_length****–**It is optional. This is the minimum length of the returned string. It must be an integer greater than or equal to 0.

### 3) Motive

- This function
**converts a number into a text representation of a given radix or base**.

### 4) Return Value

- It returns the
**text representation of the converted number**.

**Note:**

1) If the number argument is a **non-numeric value**, it returns a **#VALUE Error**.

2) The maximum length of the min_length argument is 255.

3) If the number, radix, and min_length are outside its maximum or minimum value, this function returns **#NUM!** **Error**.

## What Will BASE Function Do?

As we said earlier, the BASE function will convert a number into a text representation of a given radix. This function is categorized as “**Math**” in Excel. Let’s see an example scenario to make you understand it easily.

**Step 1:** For example, we have a **set of integer values with different base values**, and we need to convert them into a text string. For that, we can use the BASE function.

**Step 2:** Now, we need to **apply **the **following formula** in any cell where we want to get the result.

**=BASE(B3,C3)**

**Step 3:** Now, **click **on the **Enter **button to get the result.

**Step 4:** To fill down the remaining cells, you just drag down the first cell. It will **auto-fill the remaining cells** as shown in the below screenshot.

We hope that the given scenario helped you to understand the BASE function. Move to the below section if you have any confusion related to the working nature of this function.

## Alternate Example

Here we will see how to apply the BASE function in the spreadsheet with simple examples.

**1)** Suppose you want to convert a specific number into a text string based on the given radix, then you can directly apply it to the formula.

**2)** If we want to get the **decimal value** of the **13 **based on the radix “**16**“, we can apply the following formula in a cell where we want the result.

**=BASE(13,16,2)**

**3)** **Hit **the **Enter **button to get the result, as shown in the below image.

By doing so, you can quickly get the text string of the specific number based on the given radix with the help of the BASE function.

## Input that causes Error

- If the number argument is a non-numeric value, it returns
**#VALUE!**Error.

- If the number, radix, and min_length are outside its maximum or minimum value, this function returns
**#NUM!**Error.

## Citations

To understand the usage of the BASE function, we have referred to the following articles. They helped us to know the purpose of this function. You can also check them out using the links: BASE function** ^{[1]}**, and What is BASE?

**.**

^{[2]}- https://corporatefinanceinstitute.com/resources/excel/base-function/
- https://simple.wikipedia.org/wiki/Base_(mathematics)

**Wrap-Up**

With the help of the given scenarios and examples, you can easily understand the **purpose of the BASE function** **in Excel** and how to apply it in the spreadsheet. The screenshots help to learn it even easier. Drop your **feedback **in the below comment section. Thanks for visiting **AawExcel**. Keep Learning!!

If you want to know what people think about this BASE Function of Excel, then we suggest you look for it on the Quora interaction webpage. From there you can get to know more about the Excel BASE function. Here, we have provided the link to Quora’s official website.

## Video Tutorial

The following video will show you how to use the Excel BASE function in the spreadsheet with proper examples.

**Also Read:**

- How to Use Excel FLOOR.MATH Function?
- How to Use Excel FLOOR Function?
- How to Use Excel CEILING.PRECISE Function?
- How to Use Excel CEILING Function?
- How to Use Excel GCD Function?