G
Guest
does anyone know if you can fourth root numbers on an excel spreadsheet?
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
C
Conrad Carlberg
Use the caret operator and, for roots, a fraction. For example, to get the
fourth root of 16:
=16^(1/4)
fourth root of 16:
=16^(1/4)
P
Peo Sjoblom
Another way
=POWER(16,1/4)
=POWER(16,1/4)
K
kendra pieper
what is a root, and how do you get it?
N
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?
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?
G
Guest
You can just use "to the Power of" with the inverse of the number...
=16^(1/4)
=16^(1/4)
G
Guest
Fourth root is x^1/4
yth root is x^1/y
etc.
Dave
yth root is x^1/y
etc.
Dave
D
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
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