how to fourth root a number on excel

[Guest]

does anyone know if you can fourth root numbers on an excel spreadsheet?

 

[Conrad Carlberg]

Use the caret operator and, for roots, a fraction. For example, to get the
fourth root of 16:

=16^(1/4)

 

[Peo Sjoblom]

Another way

=POWER(16,1/4)

 

[kendra pieper]

what is a root, and how do you get it?

 

[Niek Otten]

Square root: =a1^(1/2)
Cubic root: =a1^(1/3)
Fourth root: =a1^(1/4)??????? Or explain what you're trying to achieve

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

| what is a root, and how do you get it?

 

[Guest]

You can just use "to the Power of" with the inverse of the number...

=16^(1/4)

 

[Guest]

Fourth root is x^1/4

yth root is x^1/y

etc.

Dave

 

[Dave Peterson]

A square root of a number is that number that you multipy by itself (used twice)
to get the original number:

The positive square root of 64 is 8 because 8*8=64.

The cube root of a number is the number that is multiplied by itself 3 times
gives the original number.

the cube root of 27 is 3 because 3*3*3=27