Syntax
=BASE(number, radix, [min_length])Arguments
| Argument | Required | Description |
|---|---|---|
number | Required | A whole number from 0 up to 2^53 |
radix | Required | The base, from 2 to 36 |
min_length | Optional | The minimum length of the result (0 to 255) |
How to use BASE
BASE takes 2 required arguments and 1 optional argument. Type =BASE( in a cell and SheetsBat shows the arguments as you go. Optional arguments are shown in square brackets; leave them out to use their default.
Examples
Each result below was calculated by the SheetsBat formula engine.
=BASE(7, 2)Result =BASE(100, 16)Result =BASE(15, 2, 10)Result Related math functions
- ASINHReturns the inverse hyperbolic sine of a number.
- ATANReturns the arctangent of a number, in radians.
- ATAN2Returns the angle, in radians, between the x axis and the line to the point (x_num, y_num).
- ATANHReturns the inverse hyperbolic tangent of a number.
- CEILINGRounds a number up to the nearest multiple of significance.
- CEILING.MATHRounds a number up to the nearest integer or multiple; mode chooses the direction for negative numbers.
- CEILING.PRECISERounds a number up to the nearest multiple, whatever the sign of the number or significance.
- COMBINReturns the number of combinations of a number of items taken a given number at a time.
- COMBINAReturns the number of combinations of items, with repetitions allowed.