The Excel EXP function returns the result of the constant e raised to the power of a number. The constant e is a numeric constant relating to exponential growth and decay whose value is approximately 2.71828. The EXP function is the inverse of the LN (natural logarithm) function.
Find the value of e raised to the power of a number
The constant e raised to the power of a number
number - The power that e is raised to.
The EXP function finds the value of the constant e raised to a given number, so you can think of the EXP function as e^(number), where e ≈ 2.718. The exponential function can be used to get the value of e by passing the number 1 as the argument.
=EXP(0)// returns 1=EXP(1)// returns 2.71828182846 (the value of e)=EXP(2)// returns 7.38905609893
The exponential function models exponential growth and has the unique property where the output of the function at a given point is proportional to the rate of change of the function at that point. The inverse of the exponential function is the natural logarithm which represents the opposite of exponential growth, exponential decay.
The Excel LOG function returns the logarithm of a given number, using a supplied base. The base argument defaults to 10 if not supplied.
Excel Formula Training
Formulas are the key to getting things done in Excel. In this accelerated training, you'll learn how to use formulas to manipulate text, work with dates and times, lookup values with VLOOKUP and INDEX & MATCH, count and sum with criteria, dynamically rank values, and create dynamic ranges. You'll also learn how to troubleshoot, trace errors, and fix problems. Instant access. See details here.