Exponential Excel Function

There is an Exponential function in the Formulas tab. We can access the function by selecting Formulas – Math & Trig – EXP.

We can apply the Exponential function in Excel VBA using the method:

Exp(number)

The argument in the above method has the same definition provided in the EXP() Excel Formula section.

Let us understand how to use the above mentioned method in Excel VBA with an example.

The following table contains a set of numbers.



Suppose the requirement is to determine the exponential values for the respective numbers provided as EXP() argument and display the results in cells B2:B5. Then, the steps to apply the EXP function in Excel VBA to get the required data in the target cells are as follows:

Step 1: With the active sheet containing the above table open, press the keys Alt + F11 to open the VBA Editor.



Step 2: Next, choose the required VBA Project and then, click Insert – Module to access a new module, Module1.




Step 3: Now, enter the code in the Module1 window to apply the above mentioned method in the target cells.



Step 4: Next, click the Run Sub/UserForm button to execute the entered code from the top menu.



Step 5: Then, go to the active worksheet to view the required exponential values in the target cells.



Remember, each EXP method in the entered code accepts the corresponding number provided in column A.

And it determines the base e raised to the power of the specified number to display the exponential value is the respective target cell.

Likewise, we can find exponential values in excel.

The inverse of the EXP function in Excel is the LN function.
For example, column A in the below table contains a list of numbers.



And column B shows how applying the EXP() within LN(), with the specified number provided as input, returns the same number, thus proving the inverse of EXP() is the LN().