BASE(number, radix [,min_length])

Returns the number converted into a text representation with the given base.

numberThe number you want to convert.
radixThe base.
min_length(Optional) The minimum length.

Remarks

* Added in Excel 2013.
* If "number" <= 0, then #NUM is returned.
* If "number" > 2^53, then #NUM is returned.
* If "radix" < 2, then #NUM is returned.
* If "radix" > 36, then #NUM is returned.
* If "min_length" < 0, then #NUM is returned.
* If "min_length" > 255, then ??
* If "number" is not numeric, then #VALUE is returned.
* If "number" is not as integer, it is truncated.
* If "radix" is not an integer, it is truncated.
* If "min_length" is not an integer, it is truncated.
* If "min_length" is included, then leading zeros are added if necessary.
* For the Microsoft documentation refer to support.office.com

 A
1??


© 2019 Better Solutions Limited. All Rights Reserved. © 2019 Better Solutions Limited Top