millhouse123
Active Member
- Joined
- Aug 22, 2006
- Messages
- 335
I am not getting the expect result when I multiply two arrays
Array1
1 5 2 4
1/5 1 1/2 1/2
1/2 2 1 2
1/4 2 1/2 1
Array2
0.5115
0.0986
0.2433
0.1466
Expected Result
2.0774
0.3958
0.9894
0.5933
My result
2.0774
2.0774
2.0774
2.0774
I am sure I am entering them as array formulas but I am not getting the right answer. I am sure this is something simple. Thanks for your help.
Array1
1 5 2 4
1/5 1 1/2 1/2
1/2 2 1 2
1/4 2 1/2 1
Array2
0.5115
0.0986
0.2433
0.1466
Expected Result
2.0774
0.3958
0.9894
0.5933
My result
2.0774
2.0774
2.0774
2.0774
I am sure I am entering them as array formulas but I am not getting the right answer. I am sure this is something simple. Thanks for your help.