This article describes the formula syntax and usage of the BASE function in Microsoft Excel.
Converts a number into a text representation with the given radix (base).
BASE(Number, Radix [Min_length])
The BASE function syntax has the following arguments.
Number Required. The number that you want to convert. Must be an integer greater than or equal to 0 and less than 2^53.
Radix Required. The base radix that you want to convert the number into. Must be an integer greater than or equal to 2 and less than or equal to 36 because Base function is a converter for binary, octal or hexadecimal numbering formats as well as it can convert the values up to the end of alphabetic.
Min_length Optional. The minimum length of the returned string. Must be an integer greater than or equal to 0.
If Number, Radix, or Min_length are outside the minimum or maximum constraints, BASE returns the #NUM! error value.
If Number is a non-numeric value, BASE returns the #VALUE! error value. Any non-integer number entered as an argument is truncated to an integer. The maximum value of the Min_length argument is 255.
How to find the binary number for given decimal number “28”?
Type the function as follows in the cell that you would like to get the result in:
For more understanding, look at the screenshot please: