Excel BASE Function
Summary
The Excel BASE function converts a number to the text representation of the given radix (base).
Purpose
Convert number to another base.
Return value
The text representation of the converted number.
Syntax
=BASE (number, radix, [min_length])
Arguments
- number - The number you want to convert to another representation.
- radix - The base of the representation being converted to.
- min_length - [optional] Guarantees the minimum length of the returned string by padding the string with zeros.
Version
Usage notes
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.
Related functions
Download 200+ Excel Shortcuts
Get over 200 Excel shortcuts for Windows and Mac in one handy PDF.
