# How to Use Excel Exponential Function of Base 10 (6 Examples)

Get FREE Advanced Excel Exercises with Solutions!

Sometimes you may need to use an exponential function. Furthermore, if you are a researcher then most of the time you may need to use the exponential function. So, if you are looking for how to use this exponential function of base 10 in Excel, then you have come to the right place. Today, in this article, I will demonstrate the exponential function of base 10 in Excel.

## 6 Ideal Examples to Use Excel Exponential Function of Base 10

Here, I will demonstrate 6 suitable examples with detailed steps on how to use this exponential function of base 10 in Excel. For your better understanding, I am going to use the following dataset. Which contains some numbers including positive, negative, and fractional. The dataset is given below. ### 1. Use Exponential Function POWER of Base 10

Here, I will use the POWER function. Basically, you can use this POWER function as an exponential function of base 10. Now, follow the steps given below.

Steps:

• Firstly, you must select a blank cell C5 where you want to keep the exponents.
• Secondly, you should use the formula given below in the C5 cell.
`=POWER(10,B5)`

Here, in this formula, the POWER function will return an exponent term. Where 10 is the base, and the cell value of B5 is the power. • Then, press ENTER to get the result. • After that, you have to drag the Fill Handle icon to AutoFill the corresponding data in the rest of the cells C6:C10. Or you can double-click on the Fill Handle icon. • Finally, you will get all the exponents keeping base 10. ### 2. Utilize LOG Function as Exponential Function of Base 10

Now, I will apply the LOG function. Actually, you can employ this LOG function as another exponential function of base 10 in Excel. Moreover, if you don’t mention the base then the LOG function itself will consider an exponential function of base 10. Now, follow the steps given below.

Steps:

• Firstly, you must select a blank cell C5 where you want to keep the exponents.
• Secondly, you should use the formula given below in the C5 cell.
`=LOG(B5,10)`

Here, in this formula, the LOG function will return an exponent term. Where the cell value of B5 is the number, and 10 is the base.

• Subsequently, press ENTER to get the result. • Then, you have to drag the Fill Handle icon to AutoFill the corresponding data in the rest of the cells C6:C10. Or you can double-click on the Fill Handle icon.
• Lastly, you will see all the exponents of base 10. Note: Here, if you notice then you will see that there is a number error (#NUM!). Because the LOG, LOG10, and LN functions will work only for positive real numbers only.

### 3. Apply Exponential Function LOG10 with Base 10 in Excel

You can employ the LOG10 function as another exponential function of base 10. Moreover, you don’t need to mention the base. Actually, the LOG10 function itself is an exponential function of base 10. Now, follow the steps given below.

Steps:

• Firstly, you must select a blank cell C5 where you want to keep the exponents.
• Secondly, you should use the formula given below in the C5 cell.
`=LOG10(B5)`

Here, in this formula, the LOG10 function will return an exponent term using base 10. Where the cell value of B5 is the number.

• Thirdly, press ENTER to get the result. • Consequently, you may drag the Fill Handle icon to AutoFill the corresponding data in the rest of the cells C6:C10. Or you can double-click on the Fill Handle icon.
• Lastly, you will get all the exponents of base 10. ### 4. Employ LN Function as an Exponential Function in Excel

You can use the LN function as another exponential function in Excel. So, follow the steps given below.

Steps:

• Firstly, you must select a blank cell C5 where you want to keep the exponents.
• Secondly, you should use the formula given below in the C5 cell.
`=LN(B5)`

Here, in this formula, the LN function will return an exponent term. Where the cell value of B5 is the number.

• Thirdly, press ENTER to get the result. • Then, you may drag the Fill Handle icon to AutoFill the corresponding data in the rest of the cells C6:C10. Or you can double-click on the Fill Handle icon.
• As a result, you will get all the exponents. ### 5. Use Generic Formula to Get Exponents in Excel

You can use a generic formula as another exponential function of base 10. Actually, I will find the exponents keeping base 10 and raise that to a specified number as power. Now, follow the steps given below.

Steps:

• Firstly, you must select a blank cell C5 where you want to keep the exponents.
• Secondly, you should use the formula given below in the C5 cell.
`=10^B5`

Here, in this formula, the cell value of B5 is that certain number.

• Thirdly, press ENTER to get the result. • After that, you have to drag the Fill Handle icon to AutoFill the corresponding data in the rest of the cells C6:C10. Or you can double-click on the Fill Handle icon.
• Consequently, you will see all the exponents of base 10. ### 6. Employing EXP as Exponential Function in Excel

Here, I will apply the EXP function. Actually, you can employ this EXP function as another exponential function in Excel but here the base is e whose numeral value is 2.71828. Now, follow the steps given below.

Steps:

• Firstly, you must select a blank cell C5 where you want to keep the exponents.
• Secondly, you should use the formula given below in the C5 cell.
`=EXP(B5)`

Here, in this formula, the EXP function will return an exponent term. Where the cell value of B5 is the number.

• Subsequently, press ENTER to get the result. • Then, you have to drag the Fill Handle icon to AutoFill the corresponding data in the rest of the cells C6:C10.
• Lastly, you will see all the exponents. ## How to Create Exponential Trendline Curve in Excel

In this section, I will show you how to create an exponential trendline curve in Excel. First, suppose you have the following dataset where all the exponents are found using the POWER function. Now, follow the steps to create the exponential trendline curve.

• Firstly, you have to select the data. Here, I have selected the range B4:C10.
• Secondly, you have to go to the Insert tab.
• Thirdly, from the Charts group section you have to choose Scatter >> then choose Scatter. • As a result, you will see the graph with points. • Then, select the curve.
• After that, go to the add elements (+) option.
• Then, from the little arrow beside Trendline >> choose Exponential. • Finally, you will see the exponential trendline curve. ## Practice Section

Now, you can practice the explained method by yourself. ## Related Articles #### Musiha Mahfuza Mukta

I am Musiha, graduated from Naval Architecture and Marine Engineering Dept., BUET, currently residing in Dhaka, Bangladesh. And my passion is to grow up my skillsets with industry demands.

We will be happy to hear your thoughts Advanced Excel Exercises with Solutions PDF  