Learn how to use the Excel SQRT function with syntax and examples.
The Microsoft Excel SQRT function returns the square root of a number.
The syntax for the Microsoft Excel SQRT function is:
SQRT( number )
number is a positive number that you wish to return the square root for.
The SQRT function can be used in the following versions of Microsoft Excel:
The SQRT function can be used in Microsoft Excel as the following type of function:
Let's look at some Excel SQRT function examples and explore how to use the SQRT function as a worksheet function in Microsoft Excel:
Based on the spreadsheet above, the following Excel SQRT examples would return:
=SQRT(A1) Result: 5 =SQRT(A2) Result: 5.796550698 =SQRT(A3) Result: #NUM! =SQRT(82.6) Result: 9.088454214
(scroll to see more)