How to Use Excel “BASE FUNCTION” in Office 365? – [using Examples]
Tags: excelbasefunctionino, excelfunctions
Published: 2020-08-21 16:58:53

---
title: How to Use Excel “BASE FUNCTION” in Office 365? – [using Examples]
published: true
date: 2020-08-18 11:36:45 UTC
tags: ExcelBASEFunctioninO,ExcelFunctions
canonical_url: https://geekexcel.com/how-to-use-excel-base-function-in-office-365-using-examples/
---

## BASE Function in Excel:

In this tutorial, we will guide you to learn how to use **Excel BASE Function in Office 365** with its syntax, description, and examples. Let’s step into this article!! Get an official version of **MS Excel** from the following link: [https://www.microsoft.com/en-in/microsoft-365/excel](https://www.microsoft.com/en-in/microsoft-365/excel)

 

## **BASE Function – Description:**

- The BASE function **converts a number into a text representation of a given radix** or base.
- For example, we take the binary digits, it can be a 1 or 0, so its radix is 2 (base 2).

## **Syntax:**

=**BASE(number, radix, [min\_length])**

### Syntax Description:

**Number** – The number which you want to convert into another representation. It must be an integer value that is greater than or equal to 0 and less than 2ˆ53.

**Radix** – The base value that you want to convert the input based on. 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.

### Note:

- If the number argument is a non-numeric value, it returns **#VALUE** Error.
- The maximum length of the min\_length argument is 255.
- If the number, radix, and min\_length are outside its maximum or minimum value, this function returns **#NUM!** Error.

## **Example:**

Let’s see some examples to make it clear.

### Example 1:

- Refer to the below example.
- You can see the numbers in **Column A** , radix in **Column B** , and min\_length in **Column C**.
- The D6 cell has shown the output of the BASE function given in the formula bar.

![](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/08/1-44.png)

### Example 2:

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

![](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/08/2-30.png)

### Example 3:

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

![](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/08/3-28.png)

- In the above image, you can see the **#NUM!** Error because of the min\_length value. As we know, min\_length doesn’t contain more than 255 characters.

## **Wrap-Up:**

In this article, you can learn how to use the **Excel BASE Function in Office 365** with its syntax, description, and examples. Share your **feedback** in the below comment section. Thanks for visiting **[Geek Excel.](https://geekexcel.com/)** Keep Learning!!

### Read Also:

- [How to Use IMSUB Function in MS Excel 365? – { With Examples }](https://geekexcel.com/how-to-use-imsub-function-in-ms-excel-365-with-examples/)
- [How to Use Excel “TYPE Function” in Office 365? – (with Examples)](https://geekexcel.com/how-to-use-excel-type-function-in-office-365-with-examples/)