The BASE function which converts a number into a text representation with the given base. The BASE function was only introduced in Excel 2013 and so is not available in earlier versions of Excel.
Syntax of the BASE Function
Number: The number that you want to convert should be an integer = 0 and < 2^53).
Radix: The base that you want to convert the supplied number should be an integer equal to or greater than 2 and should not exceed 36.
Min_length: This argument is optional. It specifies the minimum length of the returned string and it also should be an integer = 0 and < 256.
This function gives a #NUM error when the above criteria for number, radix or min_length are not fulfilled. It will give #Value error when the supplied arguments are non-numeric.
I have created the infographics for the BASE Function. With the help of these infographics, you can easily learn step by step process for using this excel functions.
Furthermore, Excel consists of many inbuilt functions which are helpful in the analytical and statistical study of number.
Simply follow the instructions in the infographics below:
If the converted number is shorter than the value of [min_length], the result is padded out with leading zeros.
If any of the supplied arguments are decimal values, the function truncates them to integers.
To learn other function like ROUNDDOWN, ABS, and TRUNC Functions, please click on the name of the function.
Additionally, you can download other accounting templates like Break Even Analysis Template, Sales Revenue Analysis Template and Invoice with GST Template from here.
We thank our readers for liking, sharing and following us on different social media platforms.
If you have any queries please share in the comment section below. I will be more than happy to assist you.
Leave a Reply