EXP Excel Formula

Author Zaheer    Category Formulas     Tags ,

Microsoft Excel program is a spreadsheet application that aid users in solving easy and complex mathematical computations. With this, lots of companies are using Excel most especially those companies that are involved in engineering, financial and accounting businesses. This is the program that runs through the use of formulas or functions. So before using it, user should learn first the syntax and codes of certain mathematical functions. Basically, the formula in Excel is just similar to the formula used during the actual computation. A good example of these functions is the EXP function.

EXP Function Description

EXP function in Excel calculates for the value of “e” raise to certain power of integer. “e” is a constant number which is equal to 2.71828182845904, the natural logarithm base. When it comes to the value of e, Excel uses a value of 2.718282. In order for the function to give correct result, the syntax to be used is:

=EXP(number)

Wherein:

number – is the value of the exponent supplied to e.  The value could be a positive or a negative integer.

Key Notes:

Aside from the syntax of the function, there are also other data that users need to pay attention and they are as follows:

  • In order to compute for the power of others bases, users must utilize the exponentiation operator which is”^”.
  • EXP function is the opposite of LN, the natural logarithm of a number.

In order to use the function efficiently, here are some helpful tips:

  • User must understand the concept behind the exponent computation. It should be well understood when and where to use the function. Users should learn the mathematical computation that the function is appropriately used.
  • Users must know the basic work of EXP function. As what is written in the description, the function computes the base number exponent which is represented by e. With this, if the mathematical problem asked to compute for the value of e raised to the fourth power, then users need to multiply the value of e which is 2.718282 four times by it.

EXP Function Example

For a better understanding of the function, below is an example to study and learn:

Compute for the value of e when it is raised to the fifth power and 100th power.

From the problem, the given values are:

number – 5 and 100

To calculate for the result with the use of the EXP function, do the following procedure:

  • Open the Microsoft Excel program.
  • From the open spreadsheet, input the given value. Make sure that each given value is entered in different cells.
  • Once all the values are entered in their corresponding cells, click one cell where you want the result to appear.
  • In the cell, type in the EXP function syntax, then click for the reference cell with the value of 5.
  • Once the value is set, press the enter key and the answer should be 148.4132
  • For e raised to 100th power, perform the same procedure but enter in the formula the cell reference which contains the value of 100.
  • For e raised to 100th power the value is equal to 2.68812E+43.

These are the steps on how to use the EXP function in Excel. With this function, errors are merely encountered due to the fact that it is only used to find the value of e.

Post comment