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

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

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

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

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

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

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

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

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

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.

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