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.

Whats the sq root of 2?

… thats the sort of thing that get you thrown of boats!

Whats the sq root of 2?

… thats the sort of thing that gets you thrown of boats!

Whats the sq root of 2?

… thats the sort of thing that gets you thrown off boats!

sorry, i think once is more than enough for such a poor comment [head hanging down].

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?

John – check the update on this post

http://www.dicks-blog.com/excel/2004/06/maxif_function.html