| Home |
| Search |
| Today's Posts |
|
|
|
#1
|
|||
|
|||
how to fourth root a number on excel
does anyone know if you can fourth root numbers on an excel spreadsheet?
|
|
#2
|
|||
|
|||
|
how to fourth root a number on excel
Use the caret operator and, for roots, a fraction. For example, to get the
fourth root of 16: =16^(1/4) -- C^2 Conrad Carlberg Excel Sales Forecasting for Dummies, Wiley, 2005 "myers291" wrote in message ... does anyone know if you can fourth root numbers on an excel spreadsheet? |
|
#3
|
|||
|
|||
|
how to fourth root a number on excel
Another way
=POWER(16,1/4) -- Regards, Peo Sjoblom "Conrad Carlberg" wrote in message k.net... Use the caret operator and, for roots, a fraction. For example, to get the fourth root of 16: =16^(1/4) -- C^2 Conrad Carlberg Excel Sales Forecasting for Dummies, Wiley, 2005 "myers291" wrote in message ... does anyone know if you can fourth root numbers on an excel spreadsheet? |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
how to fourth root a number on excel
what is a root, and how do you get it?
|
|
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
how to fourth root a number on excel
Square root: =a1^(1/2)
Cubic root: =a1^(1/3) Fourth root: =a1^(1/4)??????? Or explain what you're trying to achieve -- Kind regards, Niek Otten Microsoft MVP - Excel "kendra pieper" wrote in message . .. | what is a root, and how do you get it? |
|
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
how to fourth root a number on excel
Fourth root is x^1/4
yth root is x^1/y etc. Dave -- Brevity is the soul of wit. "Niek Otten" wrote: Square root: =a1^(1/2) Cubic root: =a1^(1/3) Fourth root: =a1^(1/4)??????? Or explain what you're trying to achieve -- Kind regards, Niek Otten Microsoft MVP - Excel "kendra pieper" wrote in message . .. | what is a root, and how do you get it? |
|
#7
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
how to fourth root a number on excel
A square root of a number is that number that you multipy by itself (used twice)
to get the original number: The positive square root of 64 is 8 because 8*8=64. The cube root of a number is the number that is multiplied by itself 3 times gives the original number. the cube root of 27 is 3 because 3*3*3=27 kendra pieper wrote: what is a root, and how do you get it? -- Dave Peterson |
|
#8
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
how to fourth root a number on excel
You can just use "to the Power of" with the inverse of the number...
=16^(1/4) -- HTH... Jim Thomlinson "unknown" wrote: |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Excel - turn a page number in a header from horizontal to vertical | Charts and Charting in Excel | |||
| Does excel have a 'cubed root' function? How can it work it out? | Excel Worksheet Functions | |||
| How do I start an Excel entry with then number 0? | Excel Discussion (Misc queries) | |||
| How to format a number in Indian style in Excel? | Excel Discussion (Misc queries) | |||
| How do you calculate the nth root of a number in Excel 2003? | Excel Worksheet Functions | |||
Hybrid Mode
