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
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(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:
- 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.
NOTE: Make sure that the SQRT will not allow negative values. Hence in place of the number, do not take “–number” values.
- Using Power function
This is another way to find the square root of any number. Check the syntax
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.
For example, in this below screenshot, you will find how to calculate the square root of the number “25”.
Suggested Read: Bullets in Excel
- 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.
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.
- 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.
Dim rg as Range
Dim lg as Long
If application.selection.cells.count>1 then
Msgbox “Please select single cell”, vbokonly, “error”
Set rg = activecell
If isnumeric(rg) = true then
Lg = rg^(1/2)
Msgbox“The Square root of “&rg&” is “&lg, vbokonly, “Square Root Value”
Msgbox“Please select a numeric value”, vbokonly, “Error”
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.
- Click on it.
- Then you will find a symbol box where there are lots of symbols available.
- Choose the required one and use it to fulfill your requirement.