Excel has the POWER-function which returns the result for a number raised to a power.
So, POWER(9;5) returns 59049
Is there any function for the calculation the other way?
.. which return 9, which is the 5th square root of 59049 .. ?
Excel has the POWER-function which returns the result for a number raised to a power.
So, POWER(9;5) returns 59049
Is there any function for the calculation the other way?
.. which return 9, which is the 5th square root of 59049 .. ?
Try:
Where n = 5
=POWER(59049,1/5)
You should hit F5, because chances are I've edited this post at least 5 times.
Example of Array Formulas
Click the * below on any post that helped you.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks