ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   find the largest value in column, put in a cell (https://www.excelbanter.com/excel-worksheet-functions/89780-find-largest-value-column-put-cell.html)

JcR

find the largest value in column, put in a cell
 
cell a1 = 9
what would the formula be to get the cubed root of the value in cell a1 ?

i found the square root formula "=SQRT(a1)" but nothing hs worked yet for
cubed root

thanks


Chip Pearson

find the largest value in column, put in a cell
 
=A1^(1/3)


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com

"JcR" wrote in message
...
cell a1 = 9
what would the formula be to get the cubed root of the value in
cell a1 ?

i found the square root formula "=SQRT(a1)" but nothing hs
worked yet for
cubed root

thanks





All times are GMT +1. The time now is 08:05 PM.

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