Excel function - product,combinations mix

Hi,

Nice to finally join this community. Hope I'm posting where I'm supposed to

Here goes. I have this project to finish by the end of the month. I need to create from scratch an excel spreadsheet capable to calculate odds/percentages/margins etc. My only concern is that I've started a couple of weeks ago, and I'm not done yet, so here I am trying to ask you guys for some assistance. Let me explain the problem.

Two columns D and N, each with 10 cells. I need to calculate the product between :

D1 X N2 N3 N4 N5 N6 N7 N8 N9 N10
D2 X N1 N3 N4 N5 N6 N7 N8 N9 N10

and so on until I reach

D2 D3 D4 D5 D6 D7 D8 D9 D10 X N1

This means there are 1022 combinations and I need to calculate the product between each combination.

If you need further info, please let me know.

Cheers,

Bogdan

What do you intend to do with these products? Sum them up? Just list them?

Transform them into percentages. After, sum the percentages up.

Cheers