ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   I need the syntax for the cube root function in excel. (https://www.excelbanter.com/excel-discussion-misc-queries/3463-i-need-syntax-cube-root-function-excel.html)

Andy

I need the syntax for the cube root function in excel.
 
I am using a spreadsheet to automate a calculation requiring the cube root of
a number.

Thank you in advance,

Ken Wright

=125^(1/3)

=POWER(125,1/3)

--
Regards
Ken....................... Microsoft MVP - Excel
Sys Spec - Win XP Pro / XL 97/00/02/03

----------------------------------------------------------------------------
It's easier to beg forgiveness than ask permission :-)
----------------------------------------------------------------------------

"Andy" wrote in message
...
I am using a spreadsheet to automate a calculation requiring the cube root

of
a number.

Thank you in advance,




Norman Jones

Hi Andy,

One way, the cube root of n:

= n^(1/3)


---
Regards,
Norman



"Andy" wrote in message
...
I am using a spreadsheet to automate a calculation requiring the cube root
of
a number.

Thank you in advance,




Ron Rosenfeld

On Mon, 10 Jan 2005 12:09:02 -0800, "Andy"
wrote:

I am using a spreadsheet to automate a calculation requiring the cube root of
a number.

Thank you in advance,


Algebra:

=n^(1/3)

n can be replaced by a number or a cell reference.


--ron


All times are GMT +1. The time now is 07:54 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com