G
Guest
how do i calculate sqaure roots in excel
B
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
=SQRT(A1) best
=A1^(1/2) so cube root is =A1^(1/3)
=POWER(A1,0.5) worst (to many keystrokes)
best wishes
G
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
=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
D
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...
=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...
G
Gord Dibben
I think it's time to call it a day<g>
Or maybe just hang up my pool cue.
Gord
Or maybe just hang up my pool cue.
Gord
S
Stan Brown
Tue, 20 Nov 2007 17:53:30 -0800 from <Gord Dibben
My Excel says 2.080084 -- do I have a bug?
My Excel says 2.080084 -- do I have a bug?
G
Gord Dibben
No.
The only bug is my posting incorrect calculations.
Gord
The only bug is my posting incorrect calculations.
Gord
D
Dave Peterson
You have to wait in line to go swimming???
Oh, wait. That's a pool queue.
Oh, wait. That's a pool queue.
S
Stan Brown
Tue, 20 Nov 2007 19:54:54 -0800 from <Gord Dibben
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."
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."