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

=BASE(number,radix,[min_length])

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