How to use the SQRT function in Excel

[numtan5839]

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
https://sites.google.com/a/utd.ac.th/itm1/thekhnikh-kar-chi-sutr
http://socialintegrated.com/excel_find_products_and_square_roots
https://support.office.com/th-th/article/sqrt-654975c2-05c4-4831-9a24-2c65e4040fdf
https://www.baanmaha.com/community/threads/41006-เอกเซล-(Excel)-กับ-คณิตศาสตร์-การหา-ค่ารากที่สอง
https://macerayarislari.com/th/300-examples/32-square-root-in-excel.html