Roots
 

How do I find a root of a numberusing either a function or anoperator i Excel
e.g. the fourth root of 64?

Hi

=POWER(64,1/4)
or
=64^(1/4)


--
Arvi Laanemets
(When sending e-mail, use address arvil<Attarkon.ee)



"Lisbeth" wrote in message
...
How do I find a root of a numberusing either a function or anoperator i
Excel
e.g. the fourth root of 64?

I would use:


=CellReftogetRootFor^(1/rootPower)
eg

=A1^(1/4)

Two ways come to mind: =64^(1/4) or =power(64,1/4)

"Lisbeth" wrote:

How do I find a root of a numberusing either a function or anoperator i Excel
e.g. the fourth root of 64?