How to use the SQRT function in Excel

Post a reply

Smilies
:icon_plusone: :like: :plusone: :gfb: :-D :) :( :-o 8O :? 8) :lol: :x :P :oops: :cry: :evil: :twisted: :roll: :wink: :!: :?: :idea: :arrow: :| :mrgreen: :angry: :baa: :biggrin:
View more smilies

BBCode is ON
[img] is ON
[flash] is OFF
[url] is ON
Smilies are ON

Topic review
   

Expand view Topic review: How to use the SQRT function in Excel

How to use the SQRT function in Excel

by numtan5839 » 18/11/2019 2:46 pm

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

Top