Enrollment for the FMVA™ Certification Program is now OPEN!

SQRT Function

Returns the square root of a positive number

What is the SQRT Function?

The SQRT Function is a Math and Trigonometry function. It will provide the square root of a positive number. The function was introduced in MS Excel 2010.

 

Formula

=SQRT(number)

 

The SQRT function uses the following argument:

  1. Number (required argument) – It is the number for which we wish to find out the square root. It must be a positive number, an Excel formula, or a function that results in a positive number.

 

How to use the SQRT Function in Excel?

To understand the uses of the SQRT function, let’s consider a few examples:

 

Example 1

Suppose we wish to find the square root of the following numbers:

  • 25
  • 49
  • 900
  • 121
  • 100

 

The formula used would be =SQRT(reference). We will get the following results:

 

SQRT Function

 

Example 2

If a number provided by a user is negative, the SQRT function will return the #NUM! error. The square root of a negative number does not exist among the set of real numbers. It is because there is no way to square a number and get a negative result.

However, if we wish to take the square root of a negative number as if it were a positive number, we need to use the ABS function. We will wrap the source number in the ABS function, which will return the absolute value of a number and ignore the sign of the given number:

Suppose we are given the data below:

 

SQRT Function - Example 2

 

To find the SQRT, we will use the formula =SQRT(ABS(ref)), as shown below:

 

SQRT Function - Example 2a

 

We get the result below:

 

SQRT Function - Example 2b

 

Things to remember about the SQRT Function

  1. #NUM! error – Occurs when the supplied number argument is negative.
  2. The SQRT function, depending on the user’s requirement, can be used along with the ABS, ROUND, ROUNDUP, and ROUNDDOWN functions.
  3. SQRT is similar to the POWER function. However, the POWER function works like an exponent in a standard math equation. For example, for the number 25, we will provide the formula =SQRT(25) and =POWER( 25, 1/2).

 

Click here to download the sample Excel file

 

Additional resources

Thanks for reading CFI’s guide to important Excel functions! By taking the time to learn and master these functions, you’ll significantly speed up your financial analysis. To learn more, check out these additional resources:

Free Excel Tutorial

To master the art of Excel, check out CFI's FREE Excel Crash Course, which teaches you how to become an Excel power user.  Learn the most important formulas, functions, and shortcuts to become confident in your financial analysis.  

Launch CFI’s Free Excel Course now to take your career to the next level and move up the ladder!