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). |