non-square root

  • Thread starter Thread starter Phosphor
  • Start date Start date
P

Phosphor

hi

what is the excel worksheet function for calculation of non-squar
roots if there is any? I could not find it in excel help.
Thanks in advance for your help,

Phospho
 
As an alternative to Frank's formula, use =POWER(A1, 1/N) where N=3 for cube
root, 4 for the fourth root etc.
 
As an alternative to Frank's formula, use =POWER(A1, 1/N) where N=3 for cube
root, 4 for the fourth root etc.
Click to expand...
...

Some alternatives have some value: =SUM(A1,A3,A8,A12) vs =A1+A3+A8+A12. Other
alternatives have questionable value: CONCATENATE("foo","bar") vs "foo"&"bar".
Using the POWER function rather than the ^ operator is more the latter than the
former. Other than eating a nested function call level, taking longer to type,
eating up more RAM and more disk storage, and recalculating slightly slower,
what are the advantages of POWER over ^ ? Does POWER suffer from less floating
point rounding error than ^ ? If it does, that'd be a good reason to use it.
Otherwise, I can't see any benefits POWER offers.
 
Back
Top