Office tutorials

Exp VBA function – How to calculate exponential value

1. Exp VBA function – Description

The Exp VBA function returns an exponential value of a number. To calculate exponential value, you should use this function. For example, exponential value from 1 is the Euler’s number ~ 2.72.

2. VBA Exp function – Syntax

Number : A numeric value used to calculate the exponential value.

Function return : Double / numeric value.

3. VBA Exp function – Example

How to use the Exp function in VBA Excel? The following are examples of using the Exp function in the VisualBasic Editor.

Example 1: Example of using the Exp VBA function – result in the MsgBox window.

Example 2: VBA Exp – example of a function – result in the Excel spreadsheet.

VBA Excel functions - Exp VBA function

VBA Excel functions – Exp VBA function

4. VB Exp function – Additional information

  • none

5. Exp VisualBasic function – Where to use?

The function can be used in: Excel 2003, Excel 2007, Excel 2010, Excel 2013, Excel 2016.

The article is part of the list of VBA Excel functions. A list of all VBA functions can be found at this address: Excel VBA functions.

Leave a Reply

Your email address will not be published.