Google Sheets Function

BASE

Converts a number into a text representation with the given radix (base).

Generate a formula with AI Same function in Excel

This function works the same in Google Sheets as it does in Excel — same syntax and arguments.

Syntax

BASE(number, radix, [min_length])

The BASE function converts a decimal number into a string representation in a specified base. It supports bases ranging from 2 to 36, allowing for easy conversion between decimal, binary, hexadecimal, and other numeral systems.

Arguments

numberrequiredThe decimal number you want to convert.
radixrequiredThe base to convert to, an integer between 2 and 36.
min_lengthoptionalThe minimum length of the returned string, padded with leading zeros if necessary.

Examples

=BASE(7, 2)

Result: 111

Converts the decimal number 7 to binary.

=BASE(255, 16, 4)

Result: 00FF

Converts 255 to hexadecimal with a minimum length of 4.

FAQ

What is the maximum radix supported by the BASE function?

The BASE function supports a maximum radix of 36.

Related functions

DECIMAL HEX2DEC BIN2DEC