BASE function

The BASE function in Excel is used to convert a number into a text representation in a specified base (from 2 to 36). It is often used in contexts involving number systems, like converting decimal numbers to binary, octal, hexadecimal, or other bases.

Syntax

=BASE(number, base, [num_digits])

Parameters

• number: The number that you want to convert. This can be a positive or negative integer. The number should be in decimal format.
• base: The base to which you want to convert the number. The base must be an integer between 2 and 36. For example, base 2 for binary, base 8 for octal, base 16 for hexadecimal, etc.
• num_digits (optional): The number of digits that should appear in the result. If this is omitted, the function will return the shortest possible text representation. If the number of digits specified is greater than the length of the result, Excel will pad with leading zeros. If it’s smaller than the length of the result, the result will be truncated.

Return Value

The BASE function returns a text value representing the number in the specified base.

How It Works

• When you use BASE, Excel converts the decimal number into the base specified, outputting the result as a text string.
• The num_digits argument can be used to control the minimum length of the output string. If the number of digits is not sufficient, Excel pads the result with leading zeros.

Example 1: Convert Decimal to Binary

To convert the decimal number 25 into binary (base 2):

=BASE(25, 2)

Result: 11001

Example 2: Convert Decimal to Hexadecimal

To convert the decimal number 255 into hexadecimal (base 16):

=BASE(255, 16)

Result: FF

Example 3: Convert Decimal to Octal

To convert the decimal number 63 into octal (base 8):

=BASE(63, 8)

Result: 77

Example 4: Convert with Specified Number of Digits

To convert the decimal number 5 to binary (base 2) with a minimum of 8 digits:

=BASE(5, 2, 8)

Result: 00000101

In this example, Excel pads the result with leading zeros to make the total length of the text string 8 characters.

Example 5: Negative Number Conversion

To convert the decimal number -100 into base 8 (octal):

=BASE(-100, 8)

Result: -144

Key Points

• BASE only works with integers. If you attempt to use a decimal number, the function will ignore the fractional part.
• The num_digits parameter is optional. If omitted, the function returns the shortest possible result.
• BASE is commonly used for working with binary, octal, and hexadecimal number systems, particularly in fields like computer science and digital electronics.

Use Cases

• Computer Science: Converting numbers between different numeral systems such as binary (base 2), octal (base 8), and hexadecimal (base 16) is common in programming, data encoding, and digital systems.
• Mathematics and Engineering: Used for numerical transformations and in applications where calculations are done in different bases (e.g., digital signal processing).
• Data Analysis: Useful in some types of data transformations, particularly in systems where numerical values need to be represented in non-decimal bases.