Excel BASE function

What is BASE function in Excel?

The Base function is one of the math functions of Excel.

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

We can find this function in Math & trig category of insert function Tab.

How to use Base function in excel

  1. Click on an empty cell (like F5 )
empty cell in excel

2. Click on the fx icon (or press shift+F3)

fx icon in excel

3. In the insert function tab you will see all functions

 insert function tab in excel

4. Select math and trig category

5. Select BASE function

6. Then select ok

math and trig function category in excel

7. In the function arguments Tab you will see BASE function

8. In the number box you must enter one number (for example 56)

9. Radix is the base number you want to convert into (for example 10)

10. Min_length is the minimum length of the returned string. if you want to add zero to begin of the string put a value more than 3

11. If you enter values(56,10,3) result will be 056, As shown below:

base function in excel

12. If you enter values(12,2,0) result will be 1100, As shown below:

base function in excel with examples

13. If you enter values(12,2,5) result will be 01100, As shown below:

the excel base function

14. You will see results in the formula result section

Things to Remember

  • The argument of this function is number
  • The argument of this function is required and not optional
  • This function is available for all excel versions(2007-2019)

Examples of BASE function in Excel

Example 1:

How to use BASE function in excel

You can see examples of BASE function below:

Examples of BASE function in Excel
base(A2,B2,C2) ----->>>>answer is  056

base(A3,B3,C3) ----->>>>answer is  1100

base(A4,B4,C4) ----->>>>answer is  01100

base(A5,B5,C5) ----->>>>answer is  000121

base(A6,B6,C6) ----->>>>answer is  0236

What is the purpose of BASE function?

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

What is the Return value of BASE function?

It returns a number.

How many arguments does BASE function have?

This function has just 1 Argument.

The argument of BASE function is number.

In the number box you must enter one number (for example 56).

Radix is the base number you want to convert into (for example 10).

Min_length is the minimum length of the returned string. if you want to add zero to begin of the string put a value more than 3.

The argument of BASE function is required and not optional.

BASE(number) = number

Which version of excel supports BASE function?

This function is available for all excel versions (2003-2019)

Errors in BASE function

BASE related functions :

Leave a Reply

Your email address will not be published. Required fields are marked *