Cube root

J

John

Is there a way to calculate the cube root within excel

I have seen the formula SQRT function but there does not apper to be one for the cube root.
 
C

Chip Pearson

John,

The Nth root of any number is that number raised to the 1/N
power, so you can use a formula like

=A1^(1/3)


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com

John said:
Is there a way to calculate the cube root within excel.

I have seen the formula SQRT function but there does not apper
Click to expand...
to be one for the cube root.
 
Top