how do i calculate sqaure roots

[jiuodlkcjl;]

how do i calculate sqaure roots in excel

 

[Bernard Liengme]

=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

 

[Gord Dibben]

=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

 

[Dave Peterson]

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]

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

Or maybe just hang up my pool cue.


Gord

 

[Stan Brown]

Tue, 20 Nov 2007 17:53:30 -0800 from <Gord Dibben

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

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

 

[Gord Dibben]

No.

The only bug is my posting incorrect calculations.


Gord

 

[Dave Peterson]

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

Oh, wait. That's a pool queue.

 

[Stan Brown]

Tue, 20 Nov 2007 19:54:54 -0800 from <Gord Dibben

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."