How to use the Excel SQRT function

SQRT or Square Root function in excel is an inbuilt arithmetic function which is used to calculate square root if a given number in excel, to use this function in excel we need to type the keyword =SQRT( and press tab button which will pop up the SQRT function for us, this function takes a single argument.

Syntax: =SQRT(number)

The SQRT function syntax has the following arguments:

  • Number (required argument) – This is the number for which we wish to find out the square root. It must be a positive number, an Excel formula, or a function that results in a positive number.

Example: Let’s look at some Excel SQRT function examples and explore how to use the SQRT function as a worksheet function in Microsoft Excel:

Syntax:  =SQRT(A2)

Result:

SQRT function - How to use the Excel SQRT function

Based on the Excel spreadsheet above, the following SQRT examples would return:

Syntax: =SQRT(A3)
Result: 4


Syntax: =SQRT(A4)
Result: 20

Syntax: =SQRT(A5)
Result: 30

Syntax: =SQRT(A6)
Result: 6

Syntax: =SQRT(A7)
Result: 7

Syntax: =SQRT(A8)
Result: 16

Syntax: =SQRT(A9)
Result: 12

Syntax: =SQRT(A10)
Result: 11

Syntax: =SQRT(A11)
Result: 10

Syntax: =SQRT(A12)
Result: #NUM!

Syntax: =SQRT(A13)
Result: #NUM!

Syntax: =SQRT(ABS(A14))
Result: 12

Note:

  • SQRT in excel can accept only numbers. If you supply anything other than the numerical value we will get VALUE!
  • SQRT function in excel an accepts only positive numbers. If you supply negative numbers it will return the result as #NUM!
  • In order to insert the square root symbol hold the ALT key and type 251 from number keypad.

Add a Comment

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