=BASE(number, radix, [min_length])One free generation or explanation per browser, shared across Excel and Google Sheets. Account usage limits apply afterward.
Need more than a single BASE formula? Try our free AI for Excel — it reads your entire spreadsheet, answers questions in plain English, and builds charts and analysis in the same chat.
number:
The integer value that you want to convert to a different base.
radix:
The base to which you want to convert the number. This must be an integer between 2 and 36.
min_length:
(Optional) The minimum length of the resulting string. If the converted number is shorter than this length, it will be padded with leading zeros.
The BASE function in Excel is a versatile tool that allows you to convert a number from one base to another. It is particularly useful when working with numerical systems such as binary, octal, decimal, and hexadecimal. The BASE function helps you understand and manipulate numbers in different numeral systems, making it easier to perform calculations and analyses that involve various bases.
In simpler terms, the BASE function allows you to convert numbers into a format that is more suitable for your specific needs, whether you are dealing with computer science applications or mathematical problems.
Imagine you are working on a project that requires you to convert decimal numbers into binary format for a computer programming task. You have the following data in an Excel spreadsheet:
| Decimal Number |
|---|
| 10 |
| 15 |
| 20 |
| 25 |
| 30 |
You want to convert these decimal numbers into binary format.
To convert the decimal number 10 into binary format, you would use the BASE formula as follows:
=BASE(A2, 2)When you apply the formula to the decimal numbers, you will get the following binary outputs:
| Decimal Number | Binary Representation |
|---|---|
| 10 | 1010 |
| 15 | 1111 |
| 20 | 10100 |
| 25 | 11001 |
| 30 | 11110 |
Here, the decimal number 10 is converted to binary as 1010.
The BASE function is particularly useful when you need to work with different numeral systems without manually converting numbers. It allows you to quickly convert and analyze data in various bases, which is essential in fields such as computer science, mathematics, and engineering.
Understanding how to use the BASE function can significantly enhance your data manipulation capabilities in Excel, enabling you to work effectively with different numeral systems.
Happy converting!
You have a table where Column A contains product codes in decimal format and you want to convert these codes to a different base for analysis. You can use the BASE function to convert the product codes from decimal to base 16 (hexadecimal). This allows for easier categorization and identification of products in systems that utilize hexadecimal codes, streamlining inventory management and reporting processes without requiring extensive programming knowledge.
Beyond the BASE function: Better Analyst is a full Excel AI that goes well past individual formulas. Upload any spreadsheet and ask questions in plain English — you'll get formulas, data analysis, and charts back in seconds. It's a free AI Excel assistant that works with any .xlsx, .xls, or .csv file — no plugins, no Microsoft 365 required.
Don't have a spreadsheet yet? Use our free AI spreadsheet generator to turn a text prompt into a downloadable Excel file — a full AI Excel sheet maker that builds headers, columns, and formulas from your description.
Create a free account for formula help, explanations, and spreadsheet analysis. Usage limits depend on your plan.
Browse our complete library of Excel formula guides
Compare your options
Open a neutral research prompt in the AI tool you already use. Compare capabilities, limitations, and fit before you choose.
AI answers can be incomplete. Check source links, current pricing, and product documentation before deciding.