UDF for x^1/3

[Guest]

How would I go about creating a UDF, call it cuberoot, which can calculate
the cube root of a number? There doesn't seem to be a built in function for
cube roots, and rather than doing something like =10^1/3, I figured I could
learn a little VBA.

Thanks,

Dave

 

[Guest]

Function cuberoot(a)
cuberoot = a ^ (1 / 3)
End Function

 

[Guest]

OK, that was easy.

Thanks.

 

[Dave Peterson]

You may want to look at =power(), too.

How would I go about creating a UDF, call it cuberoot, which can calculate
the cube root of a number? There doesn't seem to be a built in function for
cube roots, and rather than doing something like =10^1/3, I figured I could
learn a little VBA.

Thanks,

Dave

 

[Guest]

Thanks.

Doesn't POWER() do the same thing as the ^ operator?

Dave

 

[Dave Peterson]

Yep.

But you said you couldn't find a builtin function.

Thanks.

Doesn't POWER() do the same thing as the ^ operator?

Dave

 

[Guest]

Fair point, Dave.

Thanks again.

Dave