Related Function:

The BASE function converts a number into a text representation with the given radix (base).

• This function was introduced in Excel 2013 and so is not available in earlier versions.

### Syntax

#### Arguments

Argument Description
number The number that you want to convert. Must be an integer greater than or equal to 0 and less than 2^53
radix The base radix that you want to convert the number into. Must be an integer greater than or equal to 2 and less than or equal to 36
[min_length] Optional. The minimum length of the returned string

 • Must be an integer greater than or equal to 0 • If the converted number is shorter than the value of [min_length], the result is padded out with leading zeros

#### Examples

A B C
1 Formula Result Notes
2 =BASE(7,2) 111 Converts the decimal number 7 to base 2 (binary)
3 =BASE(12,2,8 ) 00001100 Converts the decimal number 12 to base 2 (binary), with a minimum length of 8
4 =BASE(100,16) 64 Converts the decimal number 100 to base 16 (hexadecimal)

#### Common Function Error(s)

Problem What went wrong
#VALUE Occurs f any of the supplied arguments are not recognized as numeric values
#NUM! Occurs if either:

 • the supplied number argument is < 0 or is ≥ 2^53 • the supplied radix argument is < 2 or > 36 • the [min_length] argument is supplied and is < 0 or ≥ 256