Table of Contents
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.