 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
| HomeDiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWordDirectoryUser Groups Related Topics Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ... |
MS Office Forum / Excel / New Users / November 2007how do i calculate sqaure roots
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  SignatureBernard V Liengme Microsoft Excel MVP www.stfx.ca/people/bliengme remove caps from email > 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 >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... > =25(1/2) returns 5 as square root > [quoted text clipped - 7 lines] > > >how do i calculate sqaure roots in excel SignatureDave Peterson I think it's time to call it a day<g> Or maybe just hang up my pool cue. Gord >Gord meant ^: > [quoted text clipped - 15 lines] >> >> >how do i calculate sqaure roots in excel You have to wait in line to go swimming??? Oh, wait. That's a pool queue. > I think it's time to call it a day<g> > [quoted text clipped - 21 lines] > >> > >> >how do i calculate sqaure roots in excel SignatureDave Peterson 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? :-) SignatureStan 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 >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? :-) Tue, 20 Nov 2007 19:54:54 -0800 from <Gord Dibben <gorddibbATshawDOTca>>: > >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." SignatureStan 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/
|
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.