The Excel SQRT function returns the square root of a positive number.
Syntax
The syntax for the SQRT function in Microsoft Excel is:
=SQRT( number )
Parameters or Arguments
number
A positive number that you wish to return the square root for.
Excel Sqrt Function Examples
The following spreadsheet shows three simple examples of the Excel Sqrt function.
Formulas:
Results:
Notes
► If the number is <0, then it will return #NUM error.
► If the number is non-numeric, then it will return #VALUE error.