Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Arthur Yeager
 
Posts: n/a
Default How do I calculate the root of a number using Excel?

The only root function I can find in Excel is the square root function. How
can I use Excel to calculate third, fourth, fifth etc.. roots of a number?
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
bpeltzer
 
Posts: n/a
Default How do I calculate the root of a number using Excel?

Use exponentiation. Ex: =64^(1/2) for square root, =64^(1/3) for cube root,
etc.

"Arthur Yeager" wrote:

The only root function I can find in Excel is the square root function. How
can I use Excel to calculate third, fourth, fifth etc.. roots of a number?

  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Arthur Yeager
 
Posts: n/a
Default How do I calculate the root of a number using Excel?

Brilliant! Thanks for the help.


"bpeltzer" wrote:

Use exponentiation. Ex: =64^(1/2) for square root, =64^(1/3) for cube root,
etc.

"Arthur Yeager" wrote:

The only root function I can find in Excel is the square root function. How
can I use Excel to calculate third, fourth, fifth etc.. roots of a number?

  #4   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 9
Default How do I calculate the root of a number using Excel?

Hi Arthur,

How can I use function for cube roots or even 4th roots

"Arthur Yeager" wrote:

The only root function I can find in Excel is the square root function. How
can I use Excel to calculate third, fourth, fifth etc.. roots of a number?

  #5   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 618
Default How do I calculate the root of a number using Excel?

Interesting to see a thread from 2005 being revived! [And I don't think
that Arthur has posted to the group since then.]

One of the answers was in that thread, but there are two easy options.
To calculate the 4th root of A1, use either
=A1^(1/4)
or
=POWER(A1,1/4)
--
David Biddulph

"John" <John @discussions.microsoft.com wrote in message
...
Hi Arthur,

How can I use function for cube roots or even 4th roots

"Arthur Yeager" wrote:

The only root function I can find in Excel is the square root function.
How
can I use Excel to calculate third, fourth, fifth etc.. roots of a
number?



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
Excel 2003 FAILS, but Excel 2000 SUCCEEDS ??? Richard Excel Discussion (Misc queries) 2 May 13th 23 11:46 AM
Access Excel Linked Text and Number Issues Scott Excel Discussion (Misc queries) 2 October 4th 05 09:24 PM
Excel not taking number format consistently KP Conrad Excel Discussion (Misc queries) 1 September 22nd 05 07:37 PM
Excel changing number formatting and source data in graphs on it's own!!! JohnHamer Excel Discussion (Misc queries) 2 September 22nd 05 02:29 PM
Does Excel 2000 have a 'datedif' function to calculate the number. Kaddy Excel Worksheet Functions 7 December 11th 04 09:53 PM


All times are GMT +1. The time now is 10:23 PM.

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

About Us

"It's about Microsoft Excel"