Excel Functions Tutorials
- Maths Functions in Excel
- ABS Function in Excel
- AGGREGATE Excel Function
- CEILING Excel Function
- COMBIN Excel Function
- COS Excel Function
- EVEN Function in Excel
- EXPONENTIAL Excel Function
- Excel Matrix Multiplication
- Excel Minus Formula
- FLOOR Function in Excel
- Histogram Formula
- INT Excel Function (Integer)
- LN Excel Function
- LOG Excel Function
- Mode in Excel
- ODD Function in Excel
- POWER Function in Excel
- PRODUCT Excel Function
- PRODUCT Formula in Excel
- PI in Excel
- Quotient in Excel
- Running Total in Excel
- RAND Excel Function
- Rand Excel Formula
- RANDBETWEEN in Excel
- MROUND in Excel
- ROUND in Excel
- ROUND Formula in Excel
- ROUNDDOWN Excel Function
- ROUNDUP Function in Excel
- SIGN Excel Function
- SIN Excel Function
- Square Root in Excel (SQRT)
- SUBTOTAL Excel Function
- SUM Function in Excel
- SUM Formula in Excel
- Excel SUM Shortcut
- SUMIF in Excel
- SUMIFS in Excel
- SUMIF Not Blank
- SUMIFS with Dates
- SUMIF Between Two Dates
- Sumif Text in Excel
- SumIf with Multiple Criteria
- SUMPRODUCT Function in Excel
- SUMPRODUCT Formula in Excel
- SUMPRODUCT with Multiple Criteria
- How to Sum Multiple Rows in Excel?
- TAN Excel Function
- TANH in Excel
- Average vs Weighted Average
- Financial Functions in Excel (17+)
- Logical Functions in Excel (15+)
- TEXT Functions in Excel (29+)
- Lookup Reference in Excel (44+)
- Date and Time Function in Excel (22+)
- Statistical Function in Excel (50+)
- Information Functions in Excel (5+)
- Excel Charts (48+)
- Excel Tools (98+)
- Excel Tips (178+)
- VBA (162+)
- Power Bi (35+)
SQRT or Square Root function in excel is an inbuilt arithmetic function which is used to calculate square root if a given number in excel, to use this function in excel 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.
Excel Square Root (Table of Contents)
- What is Square Root of a Number?
- Formula of Square Root in Excel
- How to Calculate Square Root in Excel?
Square Root Formula in Excel (SQRT)
There is a bit list of formulas in excel. SQRT in excel is one of the many MATH & TRIGNOMETRY function in excel. The square root of a number that we get if we multiply the number with the same number itself.
For example, The square of a number 25 is 5, because if we multiply the number with 5 with 5 we will get a value of 25.
We can also write the equation this way as well.
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.
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 positive number.
And off course 6 * 6 = 36 also.
So the square root of 36 is either 6 or -6.
Square Root formula 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
Square Root (SQRT) Formula in Excel
The Formula of Square Root in Excel is very simple. It includes only one parameter.
Number: This is the only parameter SQRT excel function has. We need to supply the number that we are trying to find the square root value.
One important thing we need remembers here. Square root formula in excel can return the result only for positive numbers. If we supply the negative number we will get #NUM! Error.
How to Calculate Square Root (SQRT) in Excel?
In excel we can calculate the square root in excel not only by using the square root but we have several other ways to calculate the square root value.
I have a list of numbers. We need to find the square root value.
Copy this numbers to excel.
Open the formula in B2 cell.
Now select the required cell i.e. A2 in this case.
Now drag and drop the formula to remaining cells.
In the earlier section of this article, I have mentioned that square root in excel formula can work only for positive numbers. If we supply the negative number we will get #NUM! Error.
But we can apply another formula with SQRT function excel to get this done. Now, look at the below negative numbers.
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 firstly 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 need not apply this formula separately rather we can nest this formula inside the SQRT excel function itself.
Firstly ABS function will convert the negative number to positive number and SQRT excel function will work fine because of positive number supplied by the ABS function.
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.
If I multiply the 6 with 6 I will get 36 as the 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.
By using exponential symbol we can solve this problem.
Things to Remember about SQRT Function Excel
- SQRT in excel can accept only numbers. If you supply anything other than the numerical value we will get #VALUE! error
- SQRT function in excel an accepts only positive numbers. If you supply negative numbers it will return the result as #NUM!
- In order to insert square root symbol hold the ALT key and type 251 from number keypad.
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 –