View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
hande hande is offline
external usenet poster
 
Posts: 1
Default 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