The BASE function converts a number to a given base and returns the result as a text string. Base is specified with the radix argument.
The BASE function takes three arguments: number, radix, and min_length. Number should be an integer between 1 and 2^53. If number is negative, BASE returns a #NUM! error. The radix argument is used to specify base. Radix represents the number of digits used to represent numbers and should be an integer between 2 and 36. The optional min_length argument is the minimum string length that BASE should return. When min_length is provided, BASE will pad the output with zeros as needed to achieve the length specified.
The radix argument specifies base and the output from the BASE function is a text string. For example, the formulas below convert the number 13 into text representations of 13 in base 2 (binary), base 10 (decimal), and base 16 (hexadecimal):
In the worksheet shown, the input numbers are being converted to three different representations: base 2 (binary), base 10 (decimal), and base 16 (hexadecimal). The formulas in D5, E5, and F5 are:
=BASE(B5,2)// base 2=BASE(B5,10)// base 10=BASE(B5,16)// base 16
The function also offers an optional argument min_length which will pad the returned string with zeros when its length is less than the given value. For example, the formulas below require a minimum length of 4:
=BASE(3,2,4)// returns "0011" as text=BASE(10,16,4)// returns "000A" as text
The DECIMAL function performs the opposite conversion as the BASE function: