- Advanced Excel Functions Tutorial
- Advanced Excel Functions - Home
- Compatibility Functions
- Advanced Excel Functions - Cube
- Database Functions
- Date & Time Functions
- Engineering Functions
- Financial Functions
- Information Functions
- Advanced Excel Functions - Logical
- Lookup & Reference Functions
- Math & Trignometric Functions
- Statistical Functions
- Useful Resources
- Quick Guide
- Useful Resources
- Discussion
Math and Trignometric - BASE Function
Description
The BASE function converts a number into a text representation with the given radix (base).
Syntax
BASE (Number, Radix [Min_length])
Arguments
Argument | Description | Required/Optional |
---|---|---|
Number | The number that you want to convert. Must be an integer greater than or equal to 0 and less than 2^53. | Required |
Radix | The base radix that you want to convert the number into. Must be an integer greater than or equal to 2 and less than or equal to 36. | Required |
Min_length | The minimum length of the returned string. Must be an integer greater than or equal to 0. | Optional |
Notes
Any non-integer number entered as an argument is truncated to an integer.
The maximum value of the Min_length argument is 255.
If the Min_length argument is included, leading zeros are added to the result if the result would otherwise be shorter than the minimum length specified.
For example, BASE (16,2) returns 10000, but BASE(16,2,8) returns 00010000.
If Number, Radix, or Min_length are outside the minimum or maximum constraints, BASE returns the #NUM! error value.
If any of Number, Radix, or Min_length is a non-numeric value, BASE returns the #VALUE! error value.
Applicability
Excel 2013, Excel 2016
Example
advanced_excel_math_trigonometric_functions.htm
Advertisements