Excel - Microsoft Excel Sqrt Function

Description

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

The syntax of the function is : 

SQRT( number ) 

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. 

Sqrt Function Errors

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

Common Errors