BASE
Converts a number into a text representation with the given radix (base).
Math & TrigonometryMath Basics
What it does
Converts a number into a text representation with a specified base (radix), such as binary (2) or hexadecimal (16).
Syntax
BASE(number, radix, [min_length])
Arguments
number(number) — The number to convert (integer between 0 and 2^53).radix(number) — The base to convert to (2-36).min_length(number) — Optional minimum length of the returned string (pads with zeros).
Examples
Convert to Binary
Convert 7 to binary with min length 4.
FORMULA
=BASE(7, 2, 4)
RESULT
0111
SAMPLE DATA
| A | B | |
|---|---|---|
| 1 | Number | Base |
| 2 | 7 | 2 |