Wednesday, May 7, 2014

How to calculate square root in excel

SQRT function to help you calculate Square root in Excel

Microsoft excel is an applications software mainly used for creating spreadsheets. It can also be used for creating charts other diagrams, databases. Microsoft excel is a spreadsheet program intelligent.

Square root is one of calculations in Excel

The Microsoft Excel SQRT function returns the square root of a number. The syntax for the Microsoft Excel SQRT function is: =SQRT(Number)
In spreadsheet Excel if you want to calculate square root, you would type: =SQRT(Number or Cell have number)
For Example: =SQRT(16)
How to calculate square root in excel
For Example: =SQRT(A1)
How to calculate square root in excel

Note: When you use SQRT function

Number is positive number that you wish to return the square root for.
If the negative number entered in the number parameter, the SQRT function will return the #NUM! error.
Example:  =SQRT(-16)
How to calculate square root in excel


0 comments:

Post a Comment