Finding the Root
The SQRT() function can be used to return the square root of a number. To find a different root, use the exponentiation operator (^ - the caret above the 6) and the inverse of the root. For instance:
=27^(1/3) returns the cube root of 27, or 3.
=16^(1/4) returns the 4th root of 16, or 2.
Put the “inverse” calculation in parentheses because exponentiation takes precedent over division, and you want the division to happen first.
ross:
Whats the sq root of 2?
… thats the sort of thing that get you thrown of boats!
29 June 2004, 4:31 pmross:
Whats the sq root of 2?
… thats the sort of thing that gets you thrown of boats!
29 June 2004, 4:31 pmross:
Whats the sq root of 2?
… thats the sort of thing that gets you thrown off boats!
29 June 2004, 4:32 pmross:
sorry, i think once is more than enough for such a poor comment [head hanging down].
29 June 2004, 4:34 pmGosnel John:
I have a column of numbers (16520, 16345, 19456, 16123, 16201, 19325, 19113, 16350, 16787, 16675) and want to use a function to find the highest number in the 16000 group. I think I need to use the MAX and IF Worksheet Functions, but I can’t get it. Any help?
9 July 2004, 11:10 amDick:
John - check the update on this post
http://www.dicks-blog.com/excel/2004/06/maxif_function.html
9 July 2004, 11:38 am