EDUCBA

EDUCBA

MENUMENU
  • Free Tutorials
  • Certification Courses
  • 120+ Courses All in One Bundle
  • Login
Home Excel Excel Resources Maths Function in Excel Excel Square Root Function
Secondary Sidebar
Excel Functions
  • Maths Function in Excel
    • Calculating Investment Return In Excel
    • Sumif Function Examples
    • MROUND in Excel
    • SUM Cells in Excel
    • MMULT in Excel
    • MINVERSE in Excel
    • Trunc in Excel
    • SUMIF with Text
    • COS Function in Excel
    • RANDBETWEEN in Excel
    • Excel SUMIF with OR
    • Excel DEGREES Function
    • Calculations in Excel
    • Sumif Between Two Dates
    • Calculate Income Tax in Excel
    • PRODUCT Function in Excel
    • How to Sum Multiple Rows in Excel
    • Matrix in Excel
    • ROUND Formula in Excel
    • How to SUM in Excel
    • SUMPRODUCT Formula in Excel
    • Excel Running Total
    • Excel Rounding
    • Excel Exponents
    • Excel SIN Function
    • Excel Square Root Function
    • Excel ROUNDUP Function
    • ROUND Excel Function
    • Excel ROUNDDOWN Function
    • ODD Excel Function
    • SUMPRODUCT Function in Excel
    • AGGREGATE Function in Excel
    • ABS Function in Excel
    • Excel TAN Function
    • COMBIN Function in Excel
    • CEILING Function in Excel
    • INT Excel Function
    • SUBTOTAL Function in Excel
    • LN Function in Excel
    • Excel RAND Function
    • TANH Function in Excel
    • SUMIF Function in Excel
    • SUM Function in Excel
    • POWER Function in Excel
    • EVEN Function in Excel
    • LOG Function in Excel
    • FLOOR Excel Function
  • Excel Functions (12+)
  • Excel Tools (114+)
  • Financial Functions in Excel (17+)
  • Logical Functions in Excel (14+)
  • Lookup and Reference Functions in Excel (35+)
  • TEXT and String Functions in Excel (26+)
  • Date and Time Function in Excel (24+)
  • Statistical Functions in Excel (59+)
  • Information Functions in Excel (4+)
  • Excel Charts (56+)
  • Excel Tips (222+)
  • Workplace Productivity (4+)
  • Microsoft Office Tools (15+)
  • Excel Formula and Functions (22+)
  • MS Excel Shortcuts (4+)
Excel Functions Courses
  • Online EXCEL ADVANCED Certification
  • Excel for HR Training

Excel Square Root Function

By Madhuri ThakurMadhuri Thakur

Square Root Function in Excel

Excel Square Root Function (Table of Contents)

  • Square Root in Excel
  • Where is the Square Root function found in Excel?
  • How to Use the Square Root Function in Excel?

Introduction to Square Root in Excel

There are multiple ways to calculate the square root of any number in Excel. By the first way, we find it using the SQRT function in Excel, which is available in Math and Trig category in the Insert Function option. Get the SQRT function from a relevant category, then select the number for which we want to find the square root. In another way, please select the number we want to find square root and then give it the power of ½ or 0.5. By this also, we will able to find the square root of any number. If we have any negative number, then using the SQRT function with the ABS function will give the absolute value.

Below is the Square Root Formula:

Square Root Formula

Start Your Free Excel Course

Excel functions, formula, charts, formatting creating excel dashboard & others

The Square Root formula has one argument:

  • Number: It is the number for which you want to calculate the square root. This number should be a positive number.

Where is the Square Root function found in Excel?

As we discussed in the above section, this function falls under the Math & Trig functions category, thus for this function, follow the below steps:

  • Click on the Formulas tab.
  • Click on Math & Trig option under the Function Library section. Refer to the below screenshot.

Math & Trig option

  • It will open a drop-down list of functions, and we have to select the SQRT Function as shown in the below screenshot.

SQRT Function

  • After clicking on this, it will open a Function Arguments dialog box, as shown in the below screenshot.

Function Arguments dialog box

  • Enter the value for which you want to calculate the square root under the Number field.

Number field

How to Use the Square Root Function in Excel?

It is very simple and easy to use. Let’s understand the working of the Square Root function by some Square Root Formula example.

All in One Excel VBA Bundle(120+ Courses, 30+ Projects)
Basic ExcelAdvanced ExcelVBA & MacrosExcel Dashboards
Pivot TablesStatistical FunctionsFinancial FunctionsCharts & Graphs
Price
View Courses
120+ Online Courses | 30+ Projects | 500+ Hours | Verifiable Certificates | Lifetime Access
4.9 (64,768 ratings)
You can download this Square Root Function Excel Template here – Square Root Function Excel Template

Example #1

We have given the below list of numbers.

List of numbers

Now apply the formula for the above-given number as below:

Apply the formula

The Result will be as below:

Result

Drag this formula for the rest values, and the result is shown below:

Result of Example 1-1

Example #2

The supplied number in the function should be positive. If the given number is negative, the SQRT function returns an error #NUM! Value.

Still, if you want to calculate the square root of a negative number, then first you need to convert that given number to a positive value, then you can apply the formula.

Suppose the below-given list of numbers:

Square Root Function Example 2-1

We will first use the ABS function, which returns the absolute number of a number and converts the negative number to a positive value. The ABS function ignores the sign of the given number.

Now apply the function as below:

Square Root Function Example 2-2

The Result will be as below:

Square Root Function Example 2-3

Drag & drop this function for the rest values, and the result is shown below:

Result of Example 2

Example #3

If we apply the SQRT function to a negative number, it shows an error value.

Suppose we have to calculate the square root of the number -100.

Square Root Function Example 3-1

We will apply the function here as follows:

Square Root Function Example 3-2

The result is shown below:

Result of Example 3

Things to Remember Here

  • #NUM! – This error occurs when the supplied argument of the SQRT function is a negative value.
  • The SQRT function can be used with multiple functions like ABS, ROUND, etc. depends on the result you want.
  • There is no way to square a number, and the result is of a negative number; hence the square root of a negative number doesn’t exist.

Recommended Articles

This has been a guide to Square Root in Excel. Here we discuss How to use the Square Root Function in Excel along with practical examples and a downloadable excel template. You can also go through our other suggested articles –

  1. DCOUNT Function in Excel
  2. Excel Square Root Function
  3. Excel Chi-Square Test
  4. VBA Square Root
Popular Course in this category
Excel Advanced Training (16 Courses, 23+ Projects)
  16 Online Courses |  23 Hands-on Projects |  140+ Hours |  Verifiable Certificate of Completion
4.8
Price

View Course

Related Courses

Excel for HR Training (8 Courses, 10+ Projects)4.9
0 Shares
Share
Tweet
Share
Primary Sidebar
Footer
About Us
  • Blog
  • Who is EDUCBA?
  • Sign Up
  • Live Classes
  • Corporate Training
  • Certificate from Top Institutions
  • Contact Us
  • Verifiable Certificate
  • Reviews
  • Terms and Conditions
  • Privacy Policy
  •  
Apps
  • iPhone & iPad
  • Android
Resources
  • Free Courses
  • Excel Charts
  • Excel Tips
  • All Tutorials
Certification Courses
  • All Courses
  • Excel VBA Course - All in One Bundle
  • VBA Course
  • Excel Data Analysis Course
  • Excel for Marketing Course
  • Excel for Finance Course
  • Excel for HR Training

ISO 10004:2018 & ISO 9001:2015 Certified

© 2022 - EDUCBA. ALL RIGHTS RESERVED. THE CERTIFICATION NAMES ARE THE TRADEMARKS OF THEIR RESPECTIVE OWNERS.

EDUCBA
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

By signing up, you agree to our Terms of Use and Privacy Policy.

EDUCBA Login

Forgot Password?

By signing up, you agree to our Terms of Use and Privacy Policy.

EDUCBA
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

By signing up, you agree to our Terms of Use and Privacy Policy.

EDUCBA

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

By signing up, you agree to our Terms of Use and Privacy Policy.

Let’s Get Started

By signing up, you agree to our Terms of Use and Privacy Policy.

EDUCBA

Download Square Root Function Excel Template

EDUCBA

Download Square Root Function Excel Template

EDUCBA

डाउनलोड Square Root Function Excel Template

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

Loading . . .
Quiz
Question:

Answer:

Quiz Result
Total QuestionsCorrect AnswersWrong AnswersPercentage

Explore 1000+ varieties of Mock tests View more