Reader Level:
ARTICLE

Base Function in Excel 2013

On September 25, 2012 Articles | Office 2013
In this article we will discuss how to use the Base function in Excel 2013.
  • 0
  • 0
  • 3574

This is a new function introduced in Excel 2013. This is function is used to convert a number into Text representation with a given Radix or base. In other words it will calculate the number like 102 , 88, 1616  etc. The syntax of this function is as follows: =Base(number,radix). Here we can see that The Base function takes two arguments, the first is number and the second is Radix. Here the number represents the number to which we want to represent in the text representation with a given radix and the radix specifies the base value on the basis of which we want to represent the Text.

Let's have a look at the following example:

Step 1

First go to Excel 2013.

Step 2

Now select the blank workbook template from the available templates:

bASE-FUNCTION-IN-EXCEL2013.jpg

Step 3

Now write the following numbers and their radix value:

excel2013-base-function.jpg

Step 4

Now write the formula of the base function like this:

Use-of-base-function-in-excel2013.jpg

Step 5

The output will be like this:

excel2013-with-base-function.jpg

  • 114rank
  • 404K readers
COMMENT USING

Trending up