How to use the SQRT function in Excel

Moderator: mindphp

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

How to use the SQRT function in Excel

Post by 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
Squareroot1.png (10.99 KiB) Viewed 177 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
Squareroot2.png (11.5 KiB) Viewed 177 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
Squareroot3.png (12.14 KiB) Viewed 177 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

  • Similar Topics
    Replies
    Views
    Last post

Return to “English Language”

Who is online

Users browsing this forum: No registered users and 2 guests