I can do this creating a new column B
where =POWER(A1, 10)
and then I get the result with =AVERAGE(B1:B2)
. But how to do that without a new column?
Take the 2minute tour
×
Super User is a question and answer site for computer enthusiasts and power users. It's 100% free, no registration required.



You can use an array formula to do this. Let's say your numbers to set to a power are in cells
When you are done entering the formula, you need to press Ctrl+Shift+Enter to enter it as an array formula. 

