The Excel Base function converts a number into a supplied base (radix), and returns a text representation of the calculated value.
Note: the Base function was only introduced in Excel 2013 and so is not available in earlier versions of Excel.
The syntax of the Base function is:
Where the arguments are as follows:
|number||-||The number that you want to convert (must be an integer ≥ 0 and < 2^53).|
|radix||-||The base that you want to convert the supplied number to (must be an integer ≥ 2 and ≤ 36).|
|[min_length]||-||[min_length], the result is padded out with leading zeros.If the converted number is shorter than the value of|
If any of the supplied arguments are decimal values, the function truncates them to integers.
The spreadsheet below shows three examples of the Excel Base Function.
Note that, in cell A2 of the example spreadsheet, the [min_length] argument has value 8, so the Base function pads out the result with four leading zeros.
Further details and examples of the Excel Base function are provided on the Microsoft Office website.
If you get an error from the Excel Base function, this is likely to be one of the following:
|#VALUE!||-||Occurs if any of the supplied arguments are non-numeric.|