How to use EXP POINT

EXP points are not documented in the provided context for Bing or Microsoft Rewards, so only general EXP usage in Microsoft technologies can be described.

EXP is a math function that returns the constant e (approximately 2.71828182845904), raised to the power of a given number. It is used when exponential growth or decay needs to be calculated.

Key idea:

• e is the base of natural logarithms.
• EXP(number) = e^number.
• EXP is the inverse of the natural logarithm (LN or LOG, depending on language):
  • EXP(LOG(n)) = n
  • LOG(EXP(n)) = n

Examples in different Microsoft technologies:

1. Excel EXP function

• Purpose: Returns e raised to the power of a number.
• Syntax:
  • EXP(number)
• Example formulas:
  • =EXP(1) → about 2.71828183 (the value of e)
  • =EXP(2) → about 7.3890561 (e²)
• Notes:
  • To raise other bases (like 10 or 2) to a power, use ^, for example =10^3.
  • EXP is the inverse of LN.

2. DAX EXP function (Power BI, Analysis Services)

• Purpose: Same as Excel, returns e raised to the power of a number.
• Syntax:
  • EXP(<number>)
• Example:
  • In a calculated column or measure: ExpValue = EXP([Power])
• Notes:
  • Returns a decimal number.
  • EXP is the inverse of LN.

3. SQL Server / Azure Synapse / Cosmos DB EXP

• Purpose: Compute e^x in queries. SQL Server / Azure Synapse T‑SQL:
  • Syntax: EXP ( float_expression )
  • Example:

        SELECT EXP(10);          -- e^10
        SELECT EXP(LOG(20));     -- returns 20
        SELECT LOG(EXP(20));     -- returns 20
    

  Azure Cosmos DB query language:
  • Syntax: EXP(<numeric_expr>)
  • Example:

        SELECT VALUE {
          expZero: EXP(0),
          expTen: EXP(10),
          expTwenty: EXP(20)
        }
    

4. HLSL exp (for shaders)

• Purpose: Returns e^x for each component of a float scalar, vector, or matrix.
• Syntax:
  • float r = exp(x);
• Works in Shader Model 2 and higher (and vs_1_1 in SM1).

5. VBA Exp function (Office macros)

• Purpose: Returns e raised to a power as a Double.
• Syntax:
  • Exp(number)
• Example (hyperbolic sine using Exp):

    Dim MyAngle, MyHSin
    MyAngle = 1.3
    MyHSin = (Exp(MyAngle) - Exp(-1 * MyAngle)) / 2
  

• Note: If number > 709.782712893, an overflow error occurs.

Summary of how to “use EXP” simply:

1. Decide the platform (Excel, Power BI/DAX, SQL, Cosmos DB, VBA, HLSL).
2. Pass the exponent (the power) as the argument to EXP.
3. Remember EXP always means “e to that power,” not 10 to that power.
4. Use LOG/LN with EXP when natural logs are needed, knowing they are inverse operations.

References:

• EXP function
• EXP
• EXP (Transact-SQL)
• EXP - Query language in Cosmos DB (in Azure and Fabric)