BASE Function or BASE Formula in Excel with example

BASE Function or BASE Formula in Excel with example

BASE

Function converts a number into Binary, Decimal or Hexadecimal based on input (radix) supplied into the BASE function and returns a string. Point to be noticed BASE Function is not supported in Office 2010 or lower as it was introduced Excel 2013 onward.

Syntax

=BASE(number, radix, [min_length])

Parameters

  1. number: a mandatory parameter, refers a valid number that has to be converted and should not be negative and maximum 2^53.
  2. radix: a mandatory parameter, refers to base radix in which the given input number you want to converted into. It should be a positive integer number and should be within 2 to 36 in range.
  3. min_length: an optional parameter, refers to an integer value greater than 0, minimum length of the returned result.

Formula example

Output

If you notice the result the first formula converts 58 to binary and returns default string but the third conversion puts the limit and adds leading 0s to validate the formula.

Next >> RIGHT Function in Excel with example

Leave a Reply

Your email address will not be published.