| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
UDF for x^1/3
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 -- Brevity is the soul of wit. |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
UDF for x^1/3
Function cuberoot(a)
cuberoot = a ^ (1 / 3) End Function -- Gary''s Student "Dave F" wrote: 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 -- Brevity is the soul of wit. |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
UDF for x^1/3
OK, that was easy.
Thanks. -- Brevity is the soul of wit. "Gary''s Student" wrote: Function cuberoot(a) cuberoot = a ^ (1 / 3) End Function -- Gary''s Student "Dave F" wrote: 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 -- Brevity is the soul of wit. |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
UDF for x^1/3
You may want to look at =power(), too.
Dave F wrote: 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 -- Brevity is the soul of wit. -- Dave Peterson |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
UDF for x^1/3
Thanks.
Doesn't POWER() do the same thing as the ^ operator? Dave -- Brevity is the soul of wit. "Dave Peterson" wrote: You may want to look at =power(), too. Dave F wrote: 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 -- Brevity is the soul of wit. -- Dave Peterson |
|
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
UDF for x^1/3
Yep.
But you said you couldn't find a builtin function. Dave F wrote: Thanks. Doesn't POWER() do the same thing as the ^ operator? Dave -- Brevity is the soul of wit. "Dave Peterson" wrote: You may want to look at =power(), too. Dave F wrote: 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 -- Brevity is the soul of wit. -- Dave Peterson -- Dave Peterson |
|
#7
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
UDF for x^1/3
Fair point, Dave.
Thanks again. Dave -- Brevity is the soul of wit. "Dave Peterson" wrote: Yep. But you said you couldn't find a builtin function. Dave F wrote: Thanks. Doesn't POWER() do the same thing as the ^ operator? Dave -- Brevity is the soul of wit. "Dave Peterson" wrote: You may want to look at =power(), too. Dave F wrote: 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 -- Brevity is the soul of wit. -- Dave Peterson -- Dave Peterson |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Linear Mode
