**Part 1: Introduce**

**Definition**

The EXP function in Microsoft Excel calculates the value of e raised to the power of a given number.

**Purpose**

The primary purpose of the EXP function is to return the value of e (approximately 2.71828182845904) raised to the power of a specified number.

**Syntax & Arguments**

`EXP(number)`

**Explain the Arguments in the function**

**Number**: This is a required argument. It represents the exponent applied to the base e.

**Return value**

The function returns the value of e raised to the power of the provided number.

**Remarks**

- To calculate the powers of other bases, one can use the exponentiation operator (^).
- EXP is the inverse of LN, which calculates the natural logarithm of a number.

**Part 2: Examples**

**Example 1**

**Purpose of Example**: Calculate the value of e raised to the power of 0.

**Data Sheet and Formulas**:A B C 1 **Number****Formula****Result**2 0 `=EXP(A2)`

1 3 4 **Explanation**: The formula`=EXP(0)`

returns 1 because any number raised to the power of 0 is 1.

**Example 2**

**Purpose of Example**: Calculate the value of e raised to the power of 3.

**Data Sheet and Formulas**:A B C 1 **Number****Formula****Result**2 3 `=EXP(A2)`

20.085537 3 4 **Explanation**: The formula`=EXP(3)`

calculates the base of the natural logarithm e raised to the power of 3, resulting in approximately 20.085537.

**Example 3**

**Purpose of Example**: Calculate the value of e raised to the power of -1.

**Data Sheet and Formulas**:A B C 1 **Number****Formula****Result**2 -1 `=EXP(A2)`

0.367879 3 4 **Explanation**: The formula`=EXP(-1)`

calculates the base of the natural logarithm e raised to the power of -1, resulting in approximately 0.367879.

**Example 4**

**Purpose of Example**: Calculate the value of e raised to the power of 0.5.

**Data Sheet and Formulas**:A B C 1 **Number****Formula****Result**2 0.5 `=EXP(A2)`

1.648721 3 4 **Explanation**: The formula`=EXP(0.5)`

calculates the base of the natural logarithm e raised to the power of 0.5, resulting in approximately 1.648721.

**Example 5**

**Purpose of Example**: Calculate the value of e raised to the power of -2.

**Data Sheet and Formulas**:A B C 1 **Number****Formula****Result**2 -2 `=EXP(A2)`

0.135335 3 4 **Explanation**: The formula`=EXP(-2)`

calculates the base of the natural logarithm e raised to the power of -2, resulting in approximately 0.135335.**Example 6: EXP with IF****Purpose of Example**: Determine if a number is positive and then calculate e raised to the power of that number.**Data Sheet and Formulas**:A B C 1 **Number****Formula****Result**2 2 `=IF(A2>0, EXP(A2), "Negative")`

7.389056 3 -1 `=IF(A3>0, EXP(A3), "Negative")`

Negative 4 3 `=IF(A4>0, EXP(A4), "Negative")`

20.085537 **Explanation**: This formula first checks if the number in column A is positive. If it is, it calculates e raised to the power of that number. If not, it returns “Negative”.

**Example 7: EXP with SUM****Purpose of Example**: Sum two numbers and then calculate e raised to the power of the result.**Data Sheet and Formulas**:A B C D 1 **Num1****Num2****Formula****Result**2 1 2 `=EXP(SUM(A2:B2))`

20.085537 3 2 1 `=EXP(SUM(A3:B3))`

20.085537 4 0 3 `=EXP(SUM(A4:B4))`

20.085537 **Explanation**: This formula sums the numbers in columns A and B, then calculates e raised to the power of the sum.

**Example 8: EXP with VLOOKUP****Purpose of Example**: Use VLOOKUP to find a number in a table and then calculate e raised to the power of the found number.**Data Sheet and Formulas**:A B C D 1 **Key****Value****Formula****Result**2 “A” 1 `=EXP(VLOOKUP("A", A2:B4, 2, FALSE))`

2.718282 3 “B” 2 4 “C” 3 **Explanation**: The formula uses VLOOKUP to find the key “A” in the table and retrieves its corresponding value. It then calculates e raised to the power of the retrieved value.

**Example 9: EXP with AVERAGE****Purpose of Example**: Calculate the average of a range of numbers and then compute e raised to the power of the standard.**Data Sheet and Formulas**:A B C 1 **Number****Formula****Result**2 1 `=EXP(AVERAGE(A2:A4))`

7.389056 3 2 4 3 **Explanation**: This formula calculates the average of the numbers in column A and then computes e raised to the power of the standard.

**Example 10: EXP with MAX****Purpose of Example**: Find the maximum number in a range and then calculate e raised to the power of the maximum number.**Data Sheet and Formulas**:A B C 1 **Number****Formula****Result**2 1 `=EXP(MAX(A2:A4))`

20.085537 3 2 4 3 **Explanation**: The formula finds the maximum number in column A and then calculates e raised to the power of the maximum number.

**Example 11: EXP with MIN****Purpose of Example**: Determine the minimum number in a range and then compute e raised to the power of the minimum number.**Data Sheet and Formulas**:A B C 1 **Number****Formula****Result**2 1 `=EXP(MIN(A2:A4))`

2.718282 3 2 4 3 **Explanation**: This formula identifies the minimum number in column A and then computes e raised to the power of the minimum number.

**Example 12: EXP with ROUND****Purpose of Example**: Round a number to two decimal places and then calculate e raised to the power of the rounded number.**Data Sheet and Formulas**:A B C 1 **Number****Formula****Result**2 1.55 `=EXP(ROUND(A2, 2))`

4.711165 3 2.44 `=EXP(ROUND(A3, 2))`

11.508951 4 3.33 `=EXP(ROUND(A4, 2))`

27.958577 **Explanation**: The formula rounds the numbers in column A to two decimal places and then calculates e raised to the power of the rounded number.

**Part 3: Tips and Tricks**

- Always ensure that the number provided as an argument is valid. Providing text or other non-numeric values will result in an error.
- The EXP function can be combined with other functions for more complex calculations.
- Remember that the EXP function is the inverse of the LN function. If you have the result of an EXP function, you can use the LN function to retrieve the original number.