Sqr Function

Office 2013 and later

Contribute to this content

Use GitHub to suggest and submit changes. See our guidelines for contributing to VBA documentation.

Returns a Double specifying the square root of a number.


Sqr( number )

The required number argument is a Double or any valid numeric expression greater than or equal to zero.

This example uses the Sqr function to calculate the square root of a number.

Dim MySqr
MySqr = Sqr(4)    ' Returns 2.
MySqr = Sqr(23)    ' Returns 4.79583152331272.
MySqr = Sqr(0)    ' Returns 0.
MySqr = Sqr(-4)    ' Generates a run-time error.