Finding Squares Roots, Cube Roots, and nth Roots in Excel GA S REGULAR Menu Lifewire Tech for Humans Newsletter! Search Close GO Software & Apps > MS Office 59 59 people found this article helpful

Finding Square Roots, Cube Roots, and nth Roots in Excel

Using Exponents and the SQRT Function to Find Square and Cube Roots in Excel

By Ted French Ted French Writer Former Lifewire writer Ted French is a Microsoft Certified Professional who teaches and writes about spreadsheets and spreadsheet programs. lifewire's editorial guidelines Updated on February 9, 2020 Tweet Share Email Pexels / Pixabay Tweet Share Email MS Office Excel Word Powerpoint Outlook Excel's powerful mathematical toolkit includes functions for square roots, cube roots, and even nth roots. Our review of these techniques will focus on the manual entry of formulas, but check out our tutorial on using Excel if you need a refresher on formula entry for core functions. A function's syntax refers to the layout of the function and includes the function's name, brackets, comma separators, and arguments. These steps apply to all current versions of Excel, including Excel 2019, Excel 2016, Excel 2013, Excel 2010, Excel 2019 for Mac, Excel 2016 for Mac, Excel for Mac 2011, and Excel Online.

How to Find Roots in Excel

Calculate a square root. The syntax for the SQRT() function is: =SQRT(number) For this function, you must only supply the number argument, which is the number for which a square root must be found. It can be any positive number or a cell reference to the location of the data in a worksheet. If a negative value is entered for the number argument, SQRT() returns the #NUM! error value––because multiplying two positive or two negative numbers together always returns a positive result, it is not possible to find the square root of a negative number in the set of real numbers. Calculate an nth root. Use the POWER() function to calculate any root value: =POWER(number,(1/n)) For the POWER() function, you'll supply as arguments both the number and its exponent. To calculate a root, simply supply an inverse exponent — for example, a square root is 1/2. The POWER() function is useful for both powers and exponents. For example: =POWER(4,2) yields 16, whereas: =POWER(256,(1/2)) also yields 16, which is the square root of 256. Roots are the inverse of powers. Find the cube root in Excel. To calculate the cube root of a number in Excel, use the caret operator (^) with 1/3 as the exponent in a simple formula. =number^(1/3)

In this example, the formula =D3^(1/3) is used to find the cube root of 216, which is 6. Calculate the roots of imaginary numbers. Excel offers the IMSQRT() and IMPOWER() functions to return roots and powers of imaginary numbers. The syntax of these functions is identical to the real-number versions. Was this page helpful? Thanks for letting us know! Get the Latest Tech News Delivered Every Day Subscribe Tell us why! Other Not enough details Hard to understand Submit More from Lifewire How to Use the Round Function in Excel How to Round Numbers Down in Excel With the ROUNDDOWN Function How to Combine the ROUND and SUM Functions in Excel Use Excel's EOMONTH Function to Add or Subtract Months How to Use Excel's MROUND Function How to Use the Excel DATE Function Use the Excel RIGHT Function to Extract Characters How to Use the Excel MID Function Excel SUMIFS: Sum Only Values Meeting Multiple Criteria Round up Numbers in Excel With the ROUNDUP Function How to Count Data in Selected Cells With Excel's COUNTIF Function How to Use the Excel TRUNC Function How to Find Variance in Excel How to Calculate IRR in Excel How to Use the DAY function in Excel How to Calculate Weighted Averages in Excel With SUMPRODUCT Newsletter Sign Up Newsletter Sign Up Newsletter Sign Up Newsletter Sign Up Newsletter Sign Up By clicking “Accept All Cookies”, you agree to the storing of cookies on your device to enhance site navigation, analyze site usage, and assist in our marketing efforts. Cookies Settings Accept All Cookies