The Excel BASE function returns the text representation of a number converted to another base. 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 radix value specifies the base representation of the returned text. For example, to convert the number 3 into its binary representation (base 2) the formula would be:
=BASE(3,2)// Returns "11" as text, 3 in binary (base 2)
=BASE(10,16)// Returns "A" as text, 10 in Hexadecimal (base 16)
The function also offers an optional argument min_length which will pad the returned string with zeros if is length is less than the provided value.
=BASE(3,2,4)// Returns "0011" as text=BASE(10,16,4)// Returns "000A" as text