BASE

Converts the specified number into a text representation with the give base.

Syntax

BASE( Integer x, Integer radix, [Integer minimumLength] ) → Text

Parameters

x

Required. The number to convert. Must be an integer greater than 0.

radix

Required. The base radix to convert the number to. Must be an integer in the range [2…36].

minimumLength

Optional. The minimum length of the returned string. Must be a non-negative integer.

Remarks

If any of the arguments violates its constraints, BASE returns the #NUM! error value. If the specified values are not integer, they are automatically truncated. If the minimumLength argument is specified, leading zeros are added to the result if the result would otherwise be shorter than the specified minimum length. For example, BASE(8,2) returns 1000, but BASE(8,2,8) returns 00001000.

Example

Formula

=BASE(4,2)
=BASE(4,2,8)
=BASE(1000,16)

See Also

Function Reference
DECIMAL Function