How to use the SQRT function in Excel (function (d, s, id) { var js, fjs = d.getElementsByTagName(s)[0]; if (d.getElementById(id)) return; js = d.createElement(s); js.id = id; js.src = "//connect.facebook.net/en_EN/sdk.js#xfbml=1&version=v2.3&appId="; fjs.parentNode.insertBefore(js, fjs); }(document, 'script', 'facebook-jssdk'));

Moderator: mindphp

numtan5839
PHP VIP Members
Posts: 1706
Joined: 04/11/2019 10:18 am

How to use the SQRT function in Excel

SQRT function is a function used to find the square root number.
How to remove the root in Microsoft Excel. We can't be able to add mathematical symbols.
so, we will used SQRT function.

Formula for using SQRT function
SQRT(Number)
SQRT = square root
Number = The numbers that we want to calculate.
(If Number is negative, SQRT returns the #NUM! Is an error value)

Example

formula =SQRT(4)
we want to calculate the square root of 4
result = 2
Squareroot1.png (10.99 KiB) Viewed 210 times

formula =SQRT(-4)
we want to calculate the square root of -4 so, number is negative, SQRT returns the #NUM! Is an error value.
result = #NUM!
Squareroot2.png (11.5 KiB) Viewed 210 times

formula =SQRT(ABS(-4))
we want to avoid the error message #NUM!. so, we will used ABS function to find absolute value of -4 and calculate the square root.
result = 2
Squareroot3.png (12.14 KiB) Viewed 210 times

Reference