Learn the simplest method of rooting (second root) in Excel

If you want to calculate the square root of a number in Excel, you can use the square formula. In this article, we will learn how to take the square root of a number.

You can use the SQRT function in versions: Excel2013 , Excel2010 , Excel2007 , Excel2003 .

To do this, follow these steps:

C: \ Users \ PC \ Desktop \ image-15.png

  • In cell B2, write the formula (SQRT (A2 = ).
  • By putting the formula in other cells, we get the square root of the numbers in Excel.

C: \ Users \ PC \ Desktop \ image-25.png

A few things to consider:

  • Cell B8 Error #NUM! is showing.
  • The reason for this error is the existence of a negative number.
  • Cell B9 # VALUE ! is showing.
  • The reason for this error is that the value entered can not be counted as a number.

With this method, you can calculate the square of numbers in Excel.

Leave a Reply

Your email address will not be published. Required fields are marked *