How to How to Use BASE Function in Excel in Excel - Practical Guide

Learn how to use the BASE function to convert decimal numbers into different number systems (binary, octal, hexadecimal). This tutorial covers syntax, practical examples, and real-world applications for programmers and data analysts who need to work with number base conversions in Excel.

Why This Matters

BASE function is essential for developers and IT professionals working with programming languages and binary logic in Excel. It enables quick conversion between decimal and other number systems without external tools.

Prerequisites

•Basic understanding of Excel formulas and cell references
•Knowledge of number systems (binary, octal, hexadecimal)

Step-by-Step Instructions

Open Excel and select a cell

Launch Excel and click on any empty cell where you want the result to appear.

Enter the BASE function syntax

Type the formula =BASE(number, radix) where number is the decimal value and radix is the base (2 for binary, 8 for octal, 16 for hexadecimal).

Input your decimal number

Replace 'number' with your decimal value, such as =BASE(255, 2) to convert 255 to binary.

Specify the radix parameter

Enter the target number base: use 2 for binary, 8 for octal, or 16 for hexadecimal.

Press Enter to execute

Press Enter and Excel will display the converted value as text in the selected cell.

Alternative Methods

Using cell references

Instead of hardcoding numbers, use cell references like =BASE(A1, B1) where A1 contains the decimal number and B1 contains the radix value.

Combining with other functions

Nest BASE within CONCATENATE or TEXT to format results: =CONCATENATE("Binary: ", BASE(100, 2)).

Tips & Tricks

✓BASE returns text values, not numbers—use VALUE() if you need numeric results for calculations
✓The radix parameter accepts values 2-36, allowing conversion to bases beyond common systems
✓Radix 16 produces hexadecimal values using digits 0-9 and letters A-F

Pro Tips

★Create a conversion table by using BASE in array formulas to convert multiple numbers simultaneously across different bases
★Combine BASE with SEQUENCE function to generate binary lookup tables for programming logic verification

Troubleshooting

#NUM! error appears

Check that your number is non-negative and your radix is between 2-36. Negative numbers and invalid radix values cause this error.

Result won't calculate in formulas

BASE returns text, not numbers. Wrap your formula in VALUE() to convert: =VALUE(BASE(100, 2)) for numeric use.

Unexpected decimal point in result

Ensure your number parameter is an integer; BASE doesn't handle decimal inputs and truncates them automatically.

Related Excel Formulas

DECIMAL HEX2DEC HEX2OCT HEX2BIN OCT2DEC BIN2DEC VALUE

Frequently Asked Questions

What does the BASE function do?

BASE converts a decimal number into a text representation of that number in a specified number base (radix), such as binary, octal, or hexadecimal. This is useful for programmers and technical professionals working with different numerical systems.

What is the syntax for BASE?

The syntax is =BASE(number, radix). The 'number' parameter is the decimal value to convert (must be between 0 and 2^53-1), and 'radix' is the base system (2-36) you're converting to.

Can BASE handle negative numbers?

No, BASE only works with non-negative integers. If you attempt to use a negative number, Excel returns a #NUM! error. Decimal values are truncated to integers.

Is the BASE function available in all Excel versions?

BASE was introduced in Excel 2013 and is available in all subsequent versions including Excel 2016, 2019, and Excel 365.