BASE function

Category: Math and trigonometry
Introduced: Excel 2013

Summary

Converts a number into a text representation with the given radix (base)

Syntax

BASE(Number, Radix [Min_length]) The BASE function syntax has the following arguments.
• Number Required. The number that you want to convert. Must be an integer greater than or equal to 0 and less than 2^53.
• Radix Required. 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.
• Min_length Optional. The minimum length of the returned string. Must be an integer greater than or equal to 0.

Example

=BASE(7,2)
=BASE(100,16)
=BASE(15,2,10)

Microsoft Support Page

https://support.microsoft.com/en-us/office/base-function-2ef61411-aee9-4f29-a811-1c42456c6342

Back to Functions