Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
(IF FUNTION )HOW TO SHORT THIS FORMULA?? | Excel Worksheet Functions | |||
Excel Functions- Product Array | Excel Worksheet Functions | |||
array product formulas | Excel Worksheet Functions | |||
How to find the largest product of an array of values? | Excel Worksheet Functions | |||
summing an array by product category | Excel Worksheet Functions |