Menu
EXCEL BASE FUNCTION
Excel BASE Function Introduction
The Excel Base function transforms a number to a specified base (radix) and provides the computed value as text. Because the Base function was introduced in Excel 2013, it is not available in previous versions of Excel.
Description of Excel BASE Function
Syntax :
=BASE(number, radix, [min length])
Parameters :
number -The number to be converted (must be an integer between 0 and 253).
radix-The base to which you wish to convert the given number (must be between 2 and 36).
[min length]-An optional argument that defines the minimum length of the returned string (must be an integer between 0 and 256 if given). If the converted number is less than [min length], the result is padded with leading zeros.
Step By Step Guide of BASE Function
Example :
If any of the inputs are decimal numbers, the function converts them to integers. Three instances of the Excel Base Function are shown in the spreadsheet below. Because the [min length] parameter in cell A2 of the sample spreadsheet has a value of 8, the Base function pads out the output with four leading zeros.
Key Points
- #NUM! – Occurs if any of the following conditions are met: the supplied number argument is 0 or 253; the supplied radix argument is 2 or greater than 36; and the supplied [min length] argument is 0 or 256.
- #VALUE! – This error occurs if any of the supplied parameters is not a number.
Related Functions
HLOOKUP Function
HLOOKUP Function
Explore NowVLOOKUP Function
VLOOKUP Function
Explore NowINDEX Function
INDEX Function
Explore NowMATCH Function
MATCH Function
Explore NowDATE Function
DATE Function
Explore NowIF Function
IF Function
Explore NowOR Function
OR Function
Explore NowAND Function
AND Function
Explore NowRANK Function
RANK Function
Explore NowSUMIF Function
SUMIF Function
Explore NowXIRR Function
XIRR Function
Explore NowWORKDAYS Function
WORKDAYS Function
Explore Now
