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.
![How To Calculate Square Root In Excel [Top 5 Methods] + Add Symbol](https://i2.wp.com/cdn-amgoo.nitrocdn.com/qJvQlgGQEOwNXyhUqNwiAWOQgCDvoMdJ/assets/static/optimized/rev-178a03b/wp-content/uploads/2017/11/add-square-root-symbol-in-a-cell-using-custom-formatting.png)
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:
