Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Bob Wall
 
Posts: n/a
Default Is there a simple worksheet method to determine a cube root?

Is there a simple worksheet method to determine a cube root? I can find a
square root using X^.5.
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
David Billigmeier
 
Posts: n/a
Default Is there a simple worksheet method to determine a cube root?

X^(1/3)

--
Regards,
Dave


"Bob Wall" wrote:

Is there a simple worksheet method to determine a cube root? I can find a
square root using X^.5.

  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Ron Coderre
 
Posts: n/a
Default Is there a simple worksheet method to determine a cube root?

Try this:

For a value in A1
B1: =A1^(1/3)

Does that help?

***********
Regards,
Ron

XL2002, WinXP-Pro


"Bob Wall" wrote:

Is there a simple worksheet method to determine a cube root? I can find a
square root using X^.5.

  #4   Report Post  
Posted to microsoft.public.excel.worksheet.functions
jnurse
 
Posts: n/a
Default Is there a simple worksheet method to determine a cube root?

Try using the POWER function Bob. Let's say that you want to find the cube
root of x, then =POWER(x,1/3) would work. In any case, to find the nth root
of x, the generalization is =POWER(x,1/n) or like the others suggested
=x^1/n, with n being non-zero.

"Bob Wall" wrote:

Is there a simple worksheet method to determine a cube root? I can find a
square root using X^.5.

Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
How do I convert an existing MS Excel worksheet tracking a simple. NOTANYJOE Excel Discussion (Misc queries) 1 January 4th 05 02:07 AM
How do I convert an existing MS Excel worksheet tracking a simple. [email protected] Excel Discussion (Misc queries) 0 January 4th 05 12:53 AM
why can't excel do a simple find and copy row from a worksheet to. rasman Excel Worksheet Functions 2 December 28th 04 05:49 PM
Indirect reference from one worksheet to another Bill Sturdevant Excel Worksheet Functions 2 December 17th 04 01:23 PM
Reference Data in Moved Worksheet tommcbrny Setting up and Configuration of Excel 1 December 1st 04 06:49 PM


All times are GMT +1. The time now is 11:49 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"