| Forum Home | ||||
| Press F1 | ||||
| Thread ID: 27744 | 2002-12-01 22:40:00 | finding the cube root in excel | bpt1 (419) | Press F1 |
| Post ID | Timestamp | Content | User | ||
| 102549 | 2002-12-01 22:40:00 | Anyone know the function for finding the cube or nth root of a number? | bpt1 (419) | ||
| 102550 | 2002-12-01 23:01:00 | Er just use power with 0.33333333 etc e.g. 10th root use 0.1 etc =POWER(Cellref,0.333333333333333) |
gibler (49) | ||
| 102551 | 2002-12-01 23:22:00 | Thanks | bpt1 (419) | ||
| 102552 | 2002-12-01 23:45:00 | To find the nth root of a number x, use =x^(1/n) . If x is in cell A1 and n in cell A2, then (nth root of x) =(range("A1"))^(1/range("A2")). Or however you want to do it. Excel is real good at this sort of thing. |
rugila (214) | ||
| 102553 | 2002-12-01 23:46:00 | Or if you want to save the typing use =cellref^0.333333333 |
jeep (1673) | ||
| 1 | |||||