Cube root

G

Guest

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Resume watching TV after notification on Amazon Fire Cube? 0
UDF for x^1/3 6
Cube root 5
Step by step tell me cube root (2197) which I know is 13 1
Excel Error while connecting to OLAP cube 0
Pivot Table Expand Collapse not showing for Cube 2
Excel file with olap cube gets corrupted 1
I need the syntax for the cube root function in excel. 3

Top