how do i use square root on excel - what is the formula

[Karen]

I am having difficulty using square roots - tried the help service, but
nothing was there on how to use quare root. any help i can get would be
appreciated.

karen

 

[David Biddulph]

=SQRT(A1) or =A1^0.5 or =POWER(A1,0.5)

I'm interested that you say that you've tried the help service, as when I
enter "square root" into help, the first answer I get is "SQRT worksheet
function".

 

[Roger Govier]

Hi Karen

There is an inbuilt function SQRT()
With 9 in A1
=SQRT(A1) results in 3

To Square a number or raise a number to the power of a value use
=POWER(A1,2)
This will produce 81, with 9 in A1

You can also use the caret character ^ to raise a number to the power
e.g.
=3^2 would be 3 squared = 9
To get the root of a number, it is raising a number to the reciprocal of
the power, so
=9^1/2 gives the square root of 9 = 3

 

[Gary''s Student]

Let's say we have a number like 2. Put it in cell A1. In another cell enter
the formula:

=SQRT(A1)

You will see:

1.414213562

This is the square root of two.

 

[Frank Winston]

Plenty of answers there. The only confusion I have suffered with this in the
past is that if you are working with VBA (Visual Basic for Applications) to
write a macro; there you must use sqr() for the square root function, rather
than sqrt(). I tore my hair out trying to fugure that one out years ago.
Frank