Excel Square Root (SQRT function): Multiple Ways to Calculate

If you need to find the square root of any positive number then you require to excel square root function. The SQRT is the fully automatic function that returns the square root of the number whereas the number must be a positive one. It doesn’t find the square root of any negative number. If you want to find the square root of the negative number then you need to use an absolute function.

Excel Square Root

calculate square root

To find out the Square root of any number we use SQRT. The SQRT is an inbuilt function that comes under Math/Trig function. It calculates the square root of any number that you specify in the number argument. The Syntax of the square root is

SQRT(number)

Formula Description Result
=SQRT(16) The square root of 25 4
=SQRT(A2) The square root of -16 #NUM!
=SQRT(ABS(A2)) Find absolute value of -16 4

How to calculate Excel Square Root?

There are different ways to calculate the square root of any number. Here you can check the ways:

  1. Using SQRT function

The SQRT is the specific function to calculate the square root of the number where the number is the cell reference containing the number of which you want to find a square root.

[pullquote]SQRT(Number)[/pullquote]

NOTE: Make sure that the SQRT will not allow negative values. Hence in place of the number, do not take “–number” values.

  1. Using Power function

This is another way to find the square root of any number. Check the syntax

[pullquote]POWER(number, power)[/pullquote]

Where power refers to the exponent used to raise the power, and the number is cell reference for which you want to find the square root.

Square root in excel

For example, in this below screenshot, you will find how to calculate the square root of the number “25”.

Suggested Read: Bullets in Excel

  1. Using Exponent formula

If you want to calculate the square root of any number using a simple exponent formula then you need to use the exponent operator.

[pullquote]=cell reference^(power)[/pullquote]

For example, you want to find the square root of 25 then using the exponent operator you can find out. Check the screenshot to apply yourself. To add operator you can use symbol tab.

excel square root

  1. Use VBA code

You can also use VBA code to find the square root of any number. Here is the VBA code that will return the square root of any number.

Sub getsquareroot()

Dim rg as Range

Dim lg as Long

If application.selection.cells.count>1 then

Msgbox “Please select single cell”, vbokonly, “error”

Exit sub

End if

Set rg = activecell

If isnumeric(rg) = true then

Lg = rg^(1/2)

Msgbox“The Square root of “&rg&” is “&lg, vbokonly, “Square Root Value”

Else

Msgbox“Please select a numeric value”, vbokonly, “Error”

End If

End Sub

Whenever you run this code, it checks the value mentioned in the selected cell. If it is numeric value then it will calculate the square root else it will show an error “Please select a numeric value”.

Suggested Read: Excel interview Questions

How to add Square root symbol?

There are different ways to add square root symbol:

Using Shortcut Key

  • To add square root symbol, you need to activate your num lock key.
  • Then hold down the Alt key and type 251 on the numeric keypad.
  • As you release Alt key, you will find a symbol.

Using symbol box,

  • First, go to insert tab.
  • In the Insert tab, you will find a symbol icon.

Square root symbol

  • Click on it.
  • Then you will find a symbol box where there are lots of symbols available.

Sqrt symbol

  • Choose the required one and use it to fulfill your requirement.

Leave a Reply

Your email address will not be published. Required fields are marked *