# EXP Function in Excel

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

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

### Example 1

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

• Data Sheet and Formulas:

ABC
1NumberFormulaResult
20`=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:

ABC
1NumberFormulaResult
23`=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:

ABC
1NumberFormulaResult
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:

ABC
1NumberFormulaResult
20.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:

ABC
1NumberFormulaResult
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:

ABC
1NumberFormulaResult
22`=IF(A2>0, EXP(A2), "Negative")`7.389056
3-1`=IF(A3>0, EXP(A3), "Negative")`Negative
43`=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:

ABCD
1Num1Num2FormulaResult
212`=EXP(SUM(A2:B2))`20.085537
321`=EXP(SUM(A3:B3))`20.085537
403`=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:

ABCD
1KeyValueFormulaResult
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:

ABC
1NumberFormulaResult
21`=EXP(AVERAGE(A2:A4))`7.389056
32
43
• 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:

ABC
1NumberFormulaResult
21`=EXP(MAX(A2:A4))`20.085537
32
43
• 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:

ABC
1NumberFormulaResult
21`=EXP(MIN(A2:A4))`2.718282
32
43
• 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:

ABC
1NumberFormulaResult
21.55`=EXP(ROUND(A2, 2))`4.711165
32.44`=EXP(ROUND(A3, 2))`11.508951
43.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.