Description
The Microsoft Excel SQR function returns the square root of a number.
Syntax
The syntax for the SQR function in Microsoft Excel is:
Sqr( number )
Parameters or Arguments
- number
- A positive number that you wish to return the square root for.
Note
- If a negative number is entered in the number parameter, the SQR function will raise an error.
Applies To
- Excel 2016, Excel 2013, Excel 2011 for Mac, Excel 2010, Excel 2007, Excel 2003, Excel XP, Excel 2000
Type of Function
- VBA function (VBA)
Example (as VBA Function)
The SQR function can only be used in VBA code in Microsoft Excel. If you need to calculate the square root within a worksheet formula, try the SQRT function.
Let's look at some Excel SQR function examples and explore how to use the SQR function in Excel VBA code:
=Sqr(25) Result: 5 =Sqr(30) Result: 5.47722557505166 =Sqr(2.5) Result: 1.58113883008419
For example:
Dim LResult As Double LResult = Sqr(900) Msgbox LResult
In this example, the variable called LResult would now contain the value 30.
