Function Math Complex Class

Power

"X To The Power Of Y" X and Y can be real and/or complex numbers.

Signature (Visual Basic / VBA)

Public Function Power( _
      ByVal vX As Variant _
    , ByVal vY As Variant _
    ) As Variant

Code Examples

    ? Power(-2, 3)
    -7.99999999999995|7.39933288251833E-14
    ? Power("-3|-4", 3)
    117|-43.9999999999996
    ? Power(3, "-3|-4")
    -1.15781594088179E-02|3.51807950050429E-02
    ? Power("-5|-7", "-3|-4")
    -1.09877143234855E-07|-2.19453107393805E-07
    Exponent(Logarithm(X) * Y)

Parameters

Parameter Description
vX The number which is raised to the power vY. Function returns Null if vX is Null or cannot be fixed up to a real or complex number (as defined by the ComplexStringToReals function). Complex numbers are represented within strings as "R|I" where R is the real part and I is the imaginary part.
vY The power to which vX is raised. Function returns Null if vY is Null or cannot be fixed up to a real or complex number.

Notes & Version History

Note Power(X, 2) is equivalent to but less accurate than Square (X).