Excel: Sqrt Function

In Excel, the Sqrt function returns the square root of a number.

The syntax for the Sqrt function is:

Sqrt( number )

number is a positive number that you wish to return the square root for.

Note:

If a negative number is entered in the number parameter, the Sqrt function will return the #NUM! error.

Applies To:

For example:

Let's take a look at an example:

Based on the Excel spreadsheet above:

=Sqrt(A1) would return 5

=Sqrt(A2) would return 5.796550698

=Sqrt(A3) would return #NUM!

=Sqrt(82.6) would return 9.088454214