array formula using product funtion
 

Hello,

I have such worksheet.

A B
3 1
2 2
1 3
2 4

I want my formula to take B^A and multiply every single entry.
It is gonna look like =(1^3)*(2^2)*(3^1)*(4^2) == 1*4*3*16 == 192

Basically, I like to have a single cell to have the final number. I dont
have the opportunity to create and empty column and do some calculations over
there.

Thank you so much
Hande Cardak

array formula using product funtion
 

"hande" wrote:
I want my formula to take B^A and multiply every single entry.
It is gonna look like =(1^3)*(2^2)*(3^1)*(4^2) == 1*4*3*16 == 192

Use the following array formula (press ctrl+shift+Enter instead of simply
Enter):

=PRODUCT(B1:B4^A1:A4)


----- original message -----

"hande" wrote in message
...
Hello,

I have such worksheet.

A B
3 1
2 2
1 3
2 4

I want my formula to take B^A and multiply every single entry.
It is gonna look like =(1^3)*(2^2)*(3^1)*(4^2) == 1*4*3*16 == 192

Basically, I like to have a single cell to have the final number. I dont
have the opportunity to create and empty column and do some calculations
over
there.

Thank you so much
Hande Cardak