The ‘SQRT’ function in Excel will return the square root of a given input number. The square root of a given number is the number which when multiplied by itself returns the given number. For instance, 3 squared (i.e. 3*3) is 9, and thus the square root of 9 is 3.
- The square root of 16 is 4 (4*4=16)
- The square root of 25 is 5 (5*5=16)
The formula can also handle figures where the square root is not a whole number. For example, the square root of 26 is 5.10 (to 2 decimal places).
Number – input number which you want to get the square root of
The SQRT function will return a number, representing the square root of a given input number.