by 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.
Syntax: =SQRT(number)
The SQRT function syntax has the following arguments:
- Number (required argument) – This 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.
Example: Let’s look at some Excel SQRT function examples and explore how to use the SQRT function as a worksheet function in Microsoft Excel:
Syntax: =SQRT(A2)
Result:
Based on the Excel spreadsheet above, the following SQRT examples would return:
Syntax: =SQRT(A3)
Result: 4
Syntax: =SQRT(A4)
Result: 20
Syntax: =SQRT(A5)
Result: 30
Syntax: =SQRT(A6)
Result: 6
Syntax: =SQRT(A7)
Result: 7
Syntax: =SQRT(A8)
Result: 16
Syntax: =SQRT(A9)
Result: 12
Syntax: =SQRT(A10)
Result: 11
Syntax: =SQRT(A11)
Result: 10
Syntax: =SQRT(A12)
Result: #NUM!
Syntax: =SQRT(A13)
Result: #NUM!
Syntax: =SQRT(ABS(A14))
Result: 12
Note:
- SQRT in excel can accept only numbers. If you supply anything other than the numerical value we will get VALUE!
- 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 the square root symbol hold the ALT key and type 251 from number keypad.
