how to fourth root a number on excel
 

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

how to fourth root a number on excel
 

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

=16^(1/4)

--
C^2
Conrad Carlberg

Excel Sales Forecasting for Dummies, Wiley, 2005


"myers291" wrote in message
...
does anyone know if you can fourth root numbers on an excel spreadsheet?

how to fourth root a number on excel
 

Another way

=POWER(16,1/4)

--

Regards,

Peo Sjoblom

"Conrad Carlberg" wrote in message
k.net...
Use the caret operator and, for roots, a fraction. For example, to get the
fourth root of 16:

=16^(1/4)

--
C^2
Conrad Carlberg

Excel Sales Forecasting for Dummies, Wiley, 2005


"myers291" wrote in message
...
does anyone know if you can fourth root numbers on an excel spreadsheet?

how to fourth root a number on excel
 

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

how to fourth root a number on excel
 

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

"kendra pieper" wrote in message . ..
| what is a root, and how do you get it?

how to fourth root a number on excel
 

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

=16^(1/4)
--
HTH...

Jim Thomlinson


"unknown" wrote:

how to fourth root a number on excel
 

Fourth root is x^1/4

yth root is x^1/y

etc.

Dave
--
Brevity is the soul of wit.


"Niek Otten" wrote:

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

"kendra pieper" wrote in message . ..
| what is a root, and how do you get it?

how to fourth root a number on excel
 

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



kendra pieper wrote:

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

--

Dave Peterson