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.

**Table of Contents**Expand

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

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

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

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

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

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

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.

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

- Convert Scientific Notation to x10 to the Power of 3 in Excel

- How to Estimate Inverse Exponential in Excel

- How to Make Exponent in Excel Text
- How to Use Exponent Symbol in Excel
- How to Type Exponential in Excel

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