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

BASE Function
advanced_excel_math_trigonometric_functions.htm
Advertisements