Excel SQRT Function

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.

For example:

  • 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

Function category

Maths and trigonometry


The SQRT function will return a number, representing the square root of a given input number.

Download Excel File

 Example of SQRT formula

Comments (No)

Leave a Reply

This site uses Akismet to reduce spam. Learn how your comment data is processed.