Disclosure: This post may contain affiliate links, meaning when you click the links and make a purchase, we receive a commission.

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

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.


Download Practice Workbook

You can download the practice workbook from here:


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.

Dataset to Use Excel Exponential Function of Base 10


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.

Use Exponential Function POWER of Base 10

  • 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.

Result of Using Exponential Function POWER of Base 10 in Excel

Read More: How to Make Exponent in Excel Text (7 Easy Methods)


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.

Utilize LOG Function as Exponential Function of Base 10 in Excel

  • 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.

Read More: How to Use Negative Exponents in Excel (3 Easy Methods)


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.

Apply Exponential Function LOG10 with Base 10 in Excel

  • 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.

Read More: How to Display Exponents in Excel (6 Simple Methods)


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.

Employ LN Function as an Exponential Function in Excel

  • 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.

Read More: How to Type Exponential in Excel (6 Easy Ways)


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.

Use Generic Formula to Get Exponents of Base 10 in Excel

  • 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.

Read More: How to Use Exponent Symbol in Excel (4 Easy Methods)


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.

Employing EXP as Exponential Function in Excel

  • 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.

Read More: How to Calculate Exponential in Excel (3 Easy Methods)


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.

Employing Exponential Function POWER to Create Trendline Curve in Excel

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.

How to Create Exponential Trendline Curve in Excel

  • 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.


Conclusion

I hope you found this article helpful. Here, I have explained 6 suitable examples to use Excel Exponential Function of Base 10. You can visit our website ExcelDemy to learn more Excel-related content. Please drop comments, suggestions, or queries if you have any in the comment section below.


Related Articles

Musiha

Musiha

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

Leave a reply

ExcelDemy
Logo