how do i calculate sqaure roots in excel

=SQRT(81)
=SQRT(A1) best
=A1^(1/2) so cube root is =A1^(1/3)
=POWER(A1,0.5) worst (to many keystrokes)
best wishes
--
Bernard V Liengme
Microsoft Excel MVP
www.stfx.ca/people/bliengme
remove caps from email

"jiuodlkcjl;" wrote in message
...
how do i calculate sqaure roots in excel

=25(1/2) returns 5 as square root

=9*(1/3) returns 3 as cube root

You could lso use a cell reference if the number was in a cell.

=A1(1/2)


Gord Dibben MS Excel MVP


On Tue, 20 Nov 2007 17:43:01 -0800, jiuodlkcjl;
wrote:

how do i calculate sqaure roots in excel

Gord meant ^:

=25^(1/2)
and
=9^(1/3)

And the cube root of 27 is 3. The cube root of 9 is closer to 2.08...



Gord Dibben wrote:

=25(1/2) returns 5 as square root

=9*(1/3) returns 3 as cube root

You could lso use a cell reference if the number was in a cell.

=A1(1/2)

Gord Dibben MS Excel MVP

On Tue, 20 Nov 2007 17:43:01 -0800, jiuodlkcjl;
wrote:

how do i calculate sqaure roots in excel

--

Dave Peterson

I think it's time to call it a day<g

Or maybe just hang up my pool cue.


Gord

On Tue, 20 Nov 2007 20:02:14 -0600, Dave Peterson
wrote:

Gord meant ^:

=25^(1/2)
and
=9^(1/3)

And the cube root of 27 is 3. The cube root of 9 is closer to 2.08...



Gord Dibben wrote:

=25(1/2) returns 5 as square root

=9*(1/3) returns 3 as cube root

You could lso use a cell reference if the number was in a cell.

=A1(1/2)

Gord Dibben MS Excel MVP

On Tue, 20 Nov 2007 17:43:01 -0800, jiuodlkcjl;
wrote:

how do i calculate sqaure roots in excel

Tue, 20 Nov 2007 17:53:30 -0800 from <Gord Dibben
<gorddibbATshawDOTca:
=9*(1/3) returns 3 as cube root

My Excel says 2.080084 -- do I have a bug? :-)


--
Stan Brown, Oak Road Systems, Tompkins County, New York, USA
http://OakRoadSystems.com/
"If there's one thing I know, it's men. I ought to: it's
been my life work." -- Marie Dressler, in /Dinner at Eight/

No.

The only bug is my posting incorrect calculations.


Gord

On Tue, 20 Nov 2007 22:51:02 -0500, Stan Brown
wrote:

Tue, 20 Nov 2007 17:53:30 -0800 from <Gord Dibben
<gorddibbATshawDOTca:
=9*(1/3) returns 3 as cube root

My Excel says 2.080084 -- do I have a bug? :-)

You have to wait in line to go swimming???

Oh, wait. That's a pool queue.



Gord Dibben wrote:

I think it's time to call it a day<g

Or maybe just hang up my pool cue.

Gord

On Tue, 20 Nov 2007 20:02:14 -0600, Dave Peterson
wrote:

Gord meant ^:

=25^(1/2)
and
=9^(1/3)

And the cube root of 27 is 3. The cube root of 9 is closer to 2.08...



Gord Dibben wrote:

=25(1/2) returns 5 as square root

=9*(1/3) returns 3 as cube root

You could lso use a cell reference if the number was in a cell.

=A1(1/2)

Gord Dibben MS Excel MVP

On Tue, 20 Nov 2007 17:43:01 -0800, jiuodlkcjl;
wrote:

how do i calculate sqaure roots in excel

--

Dave Peterson

Tue, 20 Nov 2007 19:54:54 -0800 from <Gord Dibben
<gorddibbATshawDOTca:
On Tue, 20 Nov 2007 22:51:02 -0500, Stan Brown
wrote:

Tue, 20 Nov 2007 17:53:30 -0800 from <Gord Dibben
<gorddibbATshawDOTca:
=9*(1/3) returns 3 as cube root

My Excel says 2.080084 -- do I have a bug? :-)

No.

The only bug is my posting incorrect calculations.

I think you missed my smiley. :-)

But when I look again, your calculation was correct. True, it didn't
calculate the cube root, but =9*(1/3) is indeed 3.

"Quit beatin' that horse, Elmer. It's DAID."

--
Stan Brown, Oak Road Systems, Tompkins County, New York, USA
http://OakRoadSystems.com/
"If there's one thing I know, it's men. I ought to: it's
been my life work." -- Marie Dressler, in /Dinner at Eight/