BASE (convert decimal number into another base)

<< Click to Display Table of Contents >>

BASE (convert decimal number into another base)

Syntax:

BASE(Number, Base [, Digits])

Description:

Converts the given decimal number (base 10) to a number with a different base – for example a binary number (base 2) or a hexadecimal number (base 16).

Note: Please note that the result of this function is a text string – not a number.

Number is the number to be converted. Only positive numbers are allowed.

Base is the target base. Only integers between 2 and 36 are allowed.

The optional argument Digits lets you specify the minimum number of places to be displayed. If omitted, PlanMaker determines the number of required places automatically. Digits must be a positive integer.

Compatibility notes:

Microsoft Excel supports this function only in version 2013 or later. In older versions, the function is unknown.

Example:

BASE(42, 2) returns 101010 (decimal number 42 displayed as binary number)

BASE(42, 2, 8) returns 00101010 (ditto, with the minimum places set to 8)

See also:

DECIMAL, DEC2BIN, DEC2HEX, DEC2OCT