array formula using product funtion

  • Thread starter Thread starter hande
  • Start date Start date
H

hande

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
(e-mail address removed)
 
hande said:
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
Click to expand...

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

=PRODUCT(B1:B4^A1:A4)


----- original message -----
 
Back
Top