![]() |
how do you calculate the 5th square root in MS Excel?
How do you calculate the square root to the fifth or square root to the fourth power, etc. in MS Excel? Thank you. |
If you mean the fifth root, or fourth root:
=A1^(1/5) or =A1^(1/4) In article , "Secrd" wrote: How do you calculate the square root to the fifth or square root to the fourth power, etc. in MS Excel? Thank you. |
Hi Secrd My interpretation of your expression, "the fifth square root" means taking successive square roots five times. That would be expressed as a power of a power such as: = A1^(1/2)^(5), or if you "know" that 2^5 = 32, then use =A1^(1/32) = A1^(1/2)^(4), or use =A1^(1/16), etc. I hope I understood you. GeorgeF -- GeorgeF ------------------------------------------------------------------------ GeorgeF's Profile: http://www.excelforum.com/member.php...o&userid=24124 View this thread: http://www.excelforum.com/showthread...hreadid=472376 |
All times are GMT +1. The time now is 01:43 AM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com