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.




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


  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