Formula to the power of....

[sobrien]

In row 1 I have numbers 1 (A1), 2 (B1), 3 (C1) and so on......
In row 2 I have random numbers
I want a formula in row 3 that multiplies the numbers in row to to the power of the numbers in row 1.

For example if in b2 I have number 3. I want it to automatically do 3x3 so should show 9 in B3
Altenratively if thed number in c2 is 6, I want it to do 6x6x6 and show 216 in c3

Thanks in advance

 

[pgc01]

Hi

In A3

=A2^A1

Copy accross

 

[sobrien]

thanks!!