BASE function:
This article describes the formula syntax and usage of the BASE function in Microsoft Excel. Description Converts a number into a text representation with the given radix (base). Syntax 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. Remarks 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. Q: 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: =BASE(28,2) For more understanding, look at the screenshot please:
0 Comments
|
Archives |