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.


How to Use Excel Exponential Function of Base 10: 6 Ideal Examples

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


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


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.


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.


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


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.


Download Practice Workbook

You can download the practice workbook from here:


Conclusion

I hope you found this article helpful. Here, I have explained 6 suitable examples of using Excel Exponential Function of Base 10. Please drop comments, suggestions, or queries if you have any in the comment section below.


Related Articles


<< Go Back to Excel EXP Function | Excel Functions | Learn Excel

What is ExcelDemy?

ExcelDemy - Learn Excel & Get Excel Solutions Center provides online Excel training , Excel consultancy services , free Excel tutorials, free support , and free Excel Templates for Excel professionals and businesses. Feel free to contact us with your Excel problems.
Musiha Mahfuza Mukta
Musiha Mahfuza Mukta

Musiha Mahfuza Mukta is a marine engineer who loves exploring Excel and VBA programming. To her, programming is a time-saving tool for dealing with data, files, and the internet. She's skilled in Rhino3D, Maxsurf, C++, MS Office, AutoCAD, and Excel & VBA, going beyond the basics. With a B.Sc in Naval Architecture & Marine Engineering from BUET, she's shifted gears and now works as a content developer. In this role, she creates techy content exclusively focused on Excel... Read Full Bio

We will be happy to hear your thoughts

Leave a reply

Advanced Excel Exercises with Solutions PDF

 

 

ExcelDemy
Logo