Raise a number to a fraction to find the square or third root

Photo of Bill Jelen By Bill Jelen

Bill Jelen is the author of 24 books on Microsoft Office Excel. He is a regular guest on TechTV with Leo Laporte and the host of MrExcel.com, which includes more than 300,000 questions and answers about Excel.


Excel offers a SQRT function to find the square root of a number. But what if you need to figure out the third root or the fourth root of a number? In this article, you'll learn how to raise a number to a fraction to find a root. For example, to find the cube root of a number, you can raise the number to the 1/3 power.

Read Article button

This article is an excerpt from Learn Excel 97-2007 from MrExcel by Bill Jelen. Buy the print edition or download a free e-book edition from MrExcel.com.

Other articles by this author

Excel 2007

Excel 2003

Applies To: Excel 2007



Was this information helpful?

Yes No

How can we improve it?

255 characters remaining

To protect your privacy, please do not include contact information in your feedback. Review our privacy policy.

Thank you for your feedback!

Support resources

Change language