BASE Function In Google Sheets

What Is BASE Function In Google Sheets?

BASE function in Google sheets is an inbuilt function used to convert the numeric values into textual representation.  It is a powerful Google sheets function which users can use to convert numbers from one base to another.

Using Google sheets BASE function, we can convert a value in the data into binary, hexadecimal value or even use a custom base representation.

For example, consider the below table showing number, and base in columns A, and B, respectively.

Now, let us use the BASE function in Google sheets and convert the numbers.

To start with, we need to insert the data in the spreadsheet. In this example, the data is available in the cell range A1:C4. Next, select the cell where we want to find the result. In this example, select the cell C2. Now, insert the BASE formula in Google sheets.

So, the complete formula is =BASE(A2,B2). Press Enter key.

We need to see the result in cell C2. Now, using AutoFill option, we can find the result in other cells such as cells C3 and C4, as shown in the below image.

In this article, let us learn how to use BASE function in Google sheets with detailed examples.

Syntax

The formula of BASE function in Google sheets is =BASE(value,base,[min_length])

where,

• Value is a mandatory argument used to convert number into base
• Base is also a mandatory argument, showing the base (from 2 to 36) used to convert number into value.
• Min_length is the optional argument used to decide and return the minimum length of the text.

Generally, while using BASE function, remember to use the BASE value from 2 to 36 in Google Sheets.

How To Use Base Function In Google Sheets?

The steps to use BASE function in Google sheets are:

Step 1: To start with, we need to insert the data in the spreadsheet. Next, select the cell where we want to find the result.

Step 2: Now, insert the BASE formula in Google sheets.

Step 3: Press Enter key.

We need to see the result in the active cell.

Likewise, we can convert numbers into different base in Google sheets.

Examples

Let us learn how to use BASE function in Google sheets with the help of followings detailed examples.

Example #1 – Convert Numbers To Binary Representation

For example, consider the below table showing number, and base in columns A, and B, respectively.

Now, let us use the BASE function in Google sheets and convert numbers to binary representation.

The steps are:

Step 1: To start with, we need to insert the data in the spreadsheet. In this example, the data is available in the cell range A1:C4. Next, select the cell where we want to find the result. In this example, select the cell C2.

Step 2: Now, insert the BASE formula in Google sheets.

So, the complete formula is =BASE(A2,B2)

Step 3: Press Enter key.

We need to see the result in cell C2.

Now, using AutoFill option, we can find the result in other cells such as cells C3 and C4, as shown in the below image.

Likewise, we can convert numbers into binary base in Google sheets.

Example #2 – Convert Numbers To Hexadecimal Representation

For example, consider the below table showing number, and base in columns A, and B, respectively.

Now, let us use the BASE function in Google sheets and convert the numbers.

The steps are:

Step 1: To start with, we need to insert the data in the spreadsheet. In this example, the data is available in the cell range A1:C4. Next, select the cell where we want to find the result. In this example, select the cell C2.

Step 2: Now, insert the BASE formula in Google sheets.

So, the complete formula is =BASE(A2,B2)

Step 3: Press Enter key.

We need to see the result in cell C2.

Now, using AutoFill option, we can find the result in other cells such as cells C3 and C4, as shown in the below image.

Likewise, we can convert numbers into hexadecimal representation in Google sheets.

Example #3 – Convert Numbers To A Custom Base Representation

For example, consider the below table showing number, and base in columns A, and B, respectively.

Now, let us use the BASE function in Google sheets and convert the numbers with the length of 6 digits.

The steps are:

Step 1: To start with, we need to insert the data in the spreadsheet. In this example, the data is available in the cell range A1:C4. Next, select the cell where we want to find the result. In this example, select the cell C2.

Step 2: Now, insert the BASE formula in Google sheets. Since our custom base length is 6, we need to mention the last argument, which is the min_length as 6.

So, the complete formula is =BASE(A2,B2,6)

Step 3: Press Enter key.

We need to see the result in cell C2.

Now, using AutoFill option, we can find the result in other cells such as cells C3 and C4, as shown in the below image.

Likewise, we can convert numbers into custom base representation in Google sheets.

Important Things To Note

• BASE function in Google sheets is used to change values into different base formats.
• It is available in both Excel and Google Sheets, which users can use to convert values into text representation.

Frequently Asked Questions

Download Template

This article must help understand BASE Function In Google Sheets with its formulas and examples. You can download the template here to use it instantly.

Recommended Articles

Guide to What is BASE Function In Google Sheets. Here we discuss how to use BASE Function In Google Sheets with its examples. You can learn more from the following articles. –

Pivot Table Update In Google Sheets

SUMIF Text In Google Sheets

Tree Map Chart In Google Sheets