

Use the formula in other cells to get the powers of irrational constant “e”.Īs you can see, the function returns the value of e and its power. The value returned here will the value of e. Here we have some numbers to give input for EXP function. Let's understand how to use the function using an example. For example when =e * e * e = e^3 or can be extracted using the below function =EXP(3).Īll of these might be confusing to understand. Let's learn more about EXP function syntax and an example to illustrate the function usage.ĮXP function returns a number when number 2.7128… which is e gets the power of number n.

This is a very valuable mathematical number and widely used in mathematics. This is generally used as the base of the natural logarithmic function. It is an irrational number written as e = 2.718281828459. Use the EXP function only to get powers of e (e = 2.7128.).Į is a euler number invented by John Napier.There are 3 ways to use Power of a number in Excel. To use this method first start with equals ( = ) sign and then use the caret ( ^ ) sign between the numbers, to Power.Īs shown in the above snapshot the 2 Power of 5 comes out to be 25, which is 5 x 5 equals 25. In simple words, the exponent of a number is, the number of times the number gets multiplied.Ĭaret ( ^ ) sign is used to take the POWER of a number. In this article, we will learn How to use the EXP Function in Excel.
