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:
|
|
A
|
B
|
|
1
|
|
=SQRT(
25 )
|
|
2
|
15625
|
=SQRT(
A2 )
|
|
3
|
6.5536
|
=SQRT(
A3 )
|
Results:
|
|
A
|
B
|
|
1
|
|
5
|
|
2
|
15625
|
125
|
|
3
|
6.5536
|
2.56
|
Notes
► If
the number is <0, then it will return #NUM error.
► If
the number is non-numeric, then it will return #VALUE error.
References
follow us on http://arivilm.blogspot.in
like us on https://www.facebook.com/Arivilm2501
No comments:
Post a Comment