How To Calculate Square Root In An Excel Formula. When writing equations with square root, the square root is written using the radical (√) symbol. =25^ (1/2) the caret symbol (^) in the formula represents the exponentiation operation.
It happens because the square root of a negative number does not. Write a root formula in excel manually (with the help of the ^ symbol) type an equal sign ( = ) in the cell where you want to put the root calculation result. To calculate square root of a number in a2, use this one: