STIS: Need some math and Excel help
|
If I have 3 options (scored 1 - 3), which could be multiplied by 3 other options (scored 1 - 3), then I want to multiply that by another option (scored 1 - 3)
So you can have:
a1, a2, a3
b1, b2, b3
c1, c2, c3
is there an easy way to find all the possible result values if you multiply each value?
There's 1*1*1, 1*1*2, 1*1*3, 1*2*1, 1*2*2, 1*2*3, etc.
How do I do that in Excel?
I know I'm thinking I'm missing something.
|