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 "number" is not as integer, it is truncated.
* If "number" is not numeric, then #VALUE is returned.
* If "radix" < 2, then #NUM is returned.
* If "radix" > 36, then #NUM is returned.
* If "radix" is not an integer, it is truncated.
* If "min_length" < 0, then #NUM is returned.
* If "min_length" > 255, then ??
* If "min_length" is not an integer, it is truncated.
* If "min_length" is included, then leading zeros are added if necessary.
* You can use the DECIMAL function to return the decimal number of a text representation of a number in a given base.
* For the Microsoft documentation refer to support.office.com

 A
1=BASE(1,2) = 1
2=BASE(2,2) = 10
3=BASE(3,2) = 11
4=BASE(10,2) = 1010
5=BASE(10,10) = 10
6=BASE(15,2,10) = 1111


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