WallStreetMojo

WallStreetMojo

WallStreetMojo

MENUMENU
  • Blog
  • Free Video Tutorials
  • Courses
  • All in One Bundle
  • Login
Home » Excel, VBA & Power BI » Excel Tutorials » Square Root in Excel (SQRT)

Square Root in Excel (SQRT)

By Jeevan A YJeevan A Y | Reviewed By Dheeraj VaidyaDheeraj Vaidya, CFA, FRM

Square Root Formula in Excel (SQRT)

Square Root function is an inbuilt arithmetic function in excel which is used to calculate square root of a given number, to use this function we need to type the keyword =SQRT and press tab button which will pop up the SQRT function for us, this function takes a single argument.

SQRT in excel is one of the many MATH & TRIGNOMETRY function in excel. The square root of a number that we get when we multiply the number with the same number itself.

For example, the square root of a number 25 is 5 because if we multiply the number 5 with 5, we will get a value 25.

We can also write the equation this way as well.

52

If you are a newbie to mathematics, you may think 5*2, which will return the result as 10. But the above equation will be solved like this

5 * 5 = 25.

Negative Square

Square root works for negative numbers as well. Now, look at the below examples.

If the number -6 is squared, we will get a positive number of 36.

-6 * -6 = +36. As per the mathematics rule, if we multiply the negative sign with the negative sign, we will get a positive number.

And off course, 6 * 6 = 36 as well.

Popular Course in this category
Sale
All in One Excel VBA Bundle (35 Courses with Projects)
4.9 (1,353 ratings)
35+ Courses | 120+ Hours | Full Lifetime Access | Certificate of Completion
View Course

So the square root of 36 is either 6 or -6.

Square Root in excel no brainer. It works exactly the same way too. With manual calculation, we need some calculators to do the task. But in excel, it’s just a supply of the number to the formula called SQRT in Excel.

Syntax

Square Root formula in excel

Number: This is the only parameter the SQRT function has. We need to supply the number that we are trying to find the square root value.

One important thing we need to remember here that the square root formula can return the result only for positive numbers. If we supply the negative number, we will get #NUM! Error.

Square Root function 1

How to Calculate Square Root (SQRT) in Excel? (With Examples)

In excel, we can calculate the square root not only by using the square root, but we have several other ways too.

You can download this Square Root Excel Template here – Square Root Excel Template

Example #1

I have a list of numbers. We need to find the square root value.

Square Root Function Example 1

Copy these numbers to excel.

Square Root Function Example 1-1

Open the formula in the B2 cell.

Square Root Function Example 1-2

Now select the required cell, i.e., A2, in this case.

Square Root Function Example 1-3

Now drag and drop the formula to the remaining cells.

Square Root Function Example 1-4

Example #2

In the earlier section of this article, I have mentioned that the square root in excel formula can work only for positive numbers. If we supply the negative number, we will get #NUM! Error.

Square Root Function Example 2

But we can apply another formula with SQRT function to get this done. Now, look at the below negative numbers.

Square Root Function Example 2-1

I have applied the SQRT Excel Function at this point in time, and I got #NUM! Errors due to negative numbers.

To solve this issue first, we need to convert all the negative numbers into positive ones. So I am going to use ABS function, which can return the absolute value of a negative number. We don’t need to apply this formula separately rather. We can nest this formula inside the SQRT function itself.

Square Root Function Example 2-2

Firstly ABS function will convert the negative number to a positive number, and the SQRT excel function will work fine because of the positive number supplied by the ABS function.

Example #3

We have learned how to calculate the square root number in excel formula. But we can find the square of the number too.

Now, look at the below numbers.

Function Example 3

If I multiply the 6 with 6, I will get 36; as a result, i.e., the square root of a number 36 is 6. But we don’t have any special formula to calculate the square value, but still, we can do this, and that is the power of Excel.

Function Example 3-1

By using an exponential symbol, we can solve this problem.

Things to Remember

  • SQRT function can accept only numbers. If you supply anything other than the numerical value, we will get #VALUE! error
  • SQRT function accepts only positive numbers. If you supply negative numbers, it will return the result as #NUM!
  • In order to insert the square root symbol, hold the ALT key and type 251 from the number keypad.

Recommended Articles

This has been a guide to Square Root in Excel. Here we discuss how to calculate Square Root using SQRT formula in excel along with examples and downloadable excel templates. You may also look at these useful functions in excel –

  • Adjusted R Squared
  • R Squared Formula
  • Excel Not Responding
  • Grade Excel Formula
4 Shares
Share
Tweet
Share
All in One Excel VBA Bundle (35 Courses with Projects)
  • 35+ Courses
  • 120+ Hours
  • Full Lifetime Access
  • Certificate of Completion
LEARN MORE >>
Primary Sidebar
Footer
COMPANY
About
Reviews
Contact
Privacy
Terms of Service
RESOURCES
Blog
Free Courses
Free Tutorials
Investment Banking Tutorials
Financial Modeling Tutorials
Excel Tutorials
Accounting Tutorials
Financial Statement Analysis
COURSES
All Courses
Financial Analyst All in One Course
Investment Banking Course
Financial Modeling Course
Private Equity Course
Venture Capital Course
Excel All in One Course

Copyright © 2021. CFA Institute Does Not Endorse, Promote, Or Warrant The Accuracy Or Quality Of WallStreetMojo. CFA® And Chartered Financial Analyst® Are Registered Trademarks Owned By CFA Institute.
Return to top

WallStreetMojo

Free Excel Course

Excel functions, Formula, Charts, Formatting creating excel dashboard & others

* Please provide your correct email id. Login details for this Free course will be emailed to you

Book Your One Instructor : One Learner Free Class
Let’s Get Started
Please select the batch
Saturday - Sunday 9 am IST to 5 pm IST
Saturday - Sunday 9 am IST to 5 pm IST

This website or its third-party tools use cookies, which are necessary to its functioning and required to achieve the purposes illustrated in the cookie policy. By closing this banner, scrolling this page, clicking a link or continuing to browse otherwise, you agree to our Privacy Policy

WallStreetMojo

Free Excel Course

Excel functions, Formula, Charts, Formatting creating excel dashboard & others

* Please provide your correct email id. Login details for this Free course will be emailed to you

Login

Forgot Password?

WallStreetMojo

Download Square Root Excel Template

Special Offer - All in One Excel VBA Bundle (35 Courses with Projects) View More