BASE FunctionWayne Becker20150925T23:13:43+00:00
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 
