## 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 168 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 168 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 168 times

Reference
http://socialintegrated.com/excel_find_products_and_square_roots
https://support.office.com/th-th/article/sqrt-654975c2-05c4-4831-9a24-2c65e4040fdf
https://macerayarislari.com/th/300-examples/32-square-root-in-excel.html

• Similar Topics
Replies
Views
Last post

### Who is online

Users browsing this forum: No registered users and 1 guest