BASE

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
* 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.
* This function was added in Excel 2013.
* For the Microsoft documentation refer to support.microsoft.com
* For the Google documentation refer to support.google.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


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