The Excel Sqrt function calculates the positive square root of a supplied number.
The syntax of the function is:
where the number argument is the numeric value that you want to find the square root of.
If the supplied number is negative, the Sqrt function returns the #NUM! error.
The following spreadsheet shows three simple examples of the Excel Sqrt function.
|
Formulas:
|
Results:
|
For further examples of the Excel Sqrt function, see the Microsoft Office website.
If you get an error from the Excel Sqrt Function, this is likely to be one of the following:
| #NUM! | - | Occurs if the supplied number is negative. |
| #VALUE! | - | Occurs if the supplied number is non-numeric. |