SQRT function in Excel returns the square root of a positive number.
Math and trigonometry
Get the square root of a positive number.
A positive square root.
number – The number for which you want the square root.
^ 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.
Excel Functions in Alphabetical Order (Complete list)
Complete List of Excel Functions (Category wise)
New Dynamic Array Functions in Excel