Exceljet

Quick, clean, and to the point

Excel BASE Function

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.

=BASE(3,2,4) // Returns "0011" as text
=BASE(10,16,4) // Returns "000A" as text

Download 200+ Excel Shortcuts

Get over 200 Excel shortcuts for Windows and Mac in one handy PDF.