The Excel SQRT Function

Home » Excel-Built-In-Functions » Excel-Math-Functions » Excel-Sqrt-Function Search this site: Custom Search

Related Function:  POWER function

Basic Description

The Excel Sqrt function calculates the positive square root of a supplied number.

The syntax of the function is :

where the number argument is a numerical value that you want to find the square root of. This can be supplied to the function either directly, as a value returned from another function, or as a reference to a cell containing a number.

Note that if the supplied number argument is negative, the Sqrt function returns the #NUM! error.

Excel Sqrt Function Examples

The following spreadsheet shows simple examples of the Excel Sqrt function. The format of the function is shown in the spreadsheet on the left and the results are shown in the spreadsheet on the right.

Formulas:

Results:

Further examples of the Excel Sqrt function can be found on the Microsoft Office website.

Sqrt Function Errors

If you get an error from the Excel Sqrt Function, this is likely to be one of the following: