SQRT Function


SQRT function in Excel returns the square root of a positive number.

Function Type

Math and trigonometry


Get the square root of a positive number.

Return value

A positive square root.




number – The number for which you want the square root.

Example 1


^ operator in Excel also can be used with the value ‘0.5’ to find the square root. For example the formula =4^0.5 will return the square root of 4.

SQRT function will return an error when a negative number is supplied into it.

Read about Excel Functions

Excel Functions in Alphabetical Order (Complete list)

Complete List of Excel Functions (Category wise)

New Dynamic Array Functions in Excel

LET Function in Excel

STOCKHISTORY Function in Excel