Power function

[Luiz]

Hi,

Anybody knows what is the difference between both codes and why the second one results in an error?

Public Sub Cardano1()
x = WorksheetFunction.Power(((-1 - Sqr(1)) / 2), 1 / 3)
End Sub

Public Sub Cardano2()
x = ((-1 - Sqr(1)) / 2) ^ (1 / 3)
End Sub

Thanks in advance,

Luiz

 

[pgc01]

Hi Luiz

You can find it in the help.

In this case, when you use the "^" operator with the exponent 1/3, you cannot use a negative number as the base.

That's why you have the error.

From the help on the "^" operator:

^ Operator
Used to raise a number to the power of an exponent.
Syntax
result = number^exponent
…

Remarks
A number can be negative only if exponent is an integer value. When more than one exponentiation is performed in a single expression, the ^ operator is evaluated as it is encountered from left to right.
…

 

[Luiz]

Thank you pgc01,

But IMHO it is a tremendous pitfall.

Luiz

 

[Luiz]

Thank you pgc01,

But IMHO it is a tremendous pitfall.

Luiz