I am trying to do an array multiplication, multiply each of the months with the corresponding numbers from the 'Array' below, for example for "Person 1" do 0.1*150, then 0.2*250 and so on.
As you can see it is returning #VALUE. Even if I try multiplying as an array, or multiply the numbers one by one it still shows #VALUE. What is the problem here and how to fix it?
As you can see it is returning #VALUE. Even if I try multiplying as an array, or multiply the numbers one by one it still shows #VALUE. What is the problem here and how to fix it?
List | Starting month | Month 1 | Month 2 | Month 3 | Month 4 | Month 5 | Month 6 | Month 7 | Month 8 | Month 9 | Month 10 | Month 11 | Month 12 | Month 13 | Month 14 | Month 15 | Month 16 | Month 17 | Month 18 | Month 19 | Month 20 | Month 21 | Month 22 | Month 23 | Month 24 | Month 25 | Month 26 | Month 27 | Month 28 | Month 29 | Month 30 | Month 31 | Month 32 | Month 33 | Month 34 | Month 35 | Month 36 |
Person 1 | 1/1/2024 | 150 | 250 | 350 | 150 | 250 | 350 | 150 | 250 | 150 | 250 | 350 | 350 | 150 | 250 | 350 | 150 | 150 | 250 | 350 | 250 | 350 | 150 | 250 | 350 | 150 | 250 | 350 | 150 | 250 | 350 | 150 | 250 | 150 | 250 | 350 | 350 |
Person 2 | 2/1/2024 | 290 | 390 | 490 | 290 | 390 | 490 | 290 | 390 | 290 | 390 | 490 | 490 | 290 | 390 | 490 | 290 | 290 | 390 | 490 | 390 | 490 | 290 | 390 | 490 | 290 | 390 | 490 | 290 | 390 | 490 | 290 | 390 | 290 | 390 | 490 | 490 |
Person 3 | 4/1/2024 | 640 | 340 | 140 | 640 | 340 | 140 | 640 | 340 | 640 | 340 | 140 | 140 | 640 | 340 | 140 | 640 | 640 | 340 | 140 | 340 | 140 | 640 | 340 | 140 | 640 | 340 | 140 | 640 | 340 | 140 | 640 | 340 | 640 | 340 | 140 | 140 |
1/1/2024 | 2/1/2024 | 3/1/2024 | 4/1/2024 | 5/1/2024 | 6/1/2024 | 7/1/2024 | 8/1/2024 | 9/1/2024 | 10/1/2024 | 11/1/2024 | 12/1/2024 | ||||||||||||||||||||||||||
0.1 | 0.2 | 0.3 | 0.4 | 0.5 | 0.6 | 0.7 | 0.8 | 0.9 | 0.8 | 0.7 | 0.6 | ||||||||||||||||||||||||||
Array | |||||||||||||||||||||||||||||||||||||
Person 1 | 1/1/2024 | 0.1 | 0.2 | 0.3 | 0.4 | 0.5 | 0.6 | 0.7 | 0.8 | 0.9 | 0.8 | 0.7 | 0.6 | 0.1 | 0.2 | 0.3 | 0.4 | 0.5 | 0.6 | 0.7 | 0.8 | 0.9 | 0.8 | 0.7 | 0.6 | 0.1 | 0.2 | 0.3 | 0.4 | 0.5 | 0.6 | 0.7 | 0.8 | 0.9 | 0.8 | 0.7 | 0.6 |
Person 2 | 2/1/2024 | 0.2 | 0.3 | 0.4 | 0.5 | 0.6 | 0.7 | 0.8 | 0.9 | 0.8 | 0.7 | 0.6 | 0.1 | 0.2 | 0.3 | 0.4 | 0.5 | 0.6 | 0.7 | 0.8 | 0.9 | 0.8 | 0.7 | 0.6 | 0.1 | 0.2 | 0.3 | 0.4 | 0.5 | 0.6 | 0.7 | 0.8 | 0.9 | 0.8 | 0.7 | 0.6 | 0.1 |
Person 3 | 4/1/2024 | 0.4 | 0.5 | 0.6 | 0.7 | 0.8 | 0.9 | 0.8 | 0.7 | 0.6 | 0.1 | 0.2 | 0.3 | 0.4 | 0.5 | 0.6 | 0.7 | 0.8 | 0.9 | 0.8 | 0.7 | 0.6 | 0.1 | 0.2 | 0.3 | 0.4 | 0.5 | 0.6 | 0.7 | 0.8 | 0.9 | 0.8 | 0.7 | 0.6 | 0.1 | 0.2 | 0.3 |
#VALUE! | #VALUE! | #VALUE! | #VALUE! | #VALUE! | #VALUE! | #VALUE! | #VALUE! | #VALUE! | #VALUE! | #VALUE! | #VALUE! | #VALUE! | #VALUE! | #VALUE! | #VALUE! | #VALUE! | #VALUE! | #VALUE! | #VALUE! | #VALUE! | #VALUE! | #VALUE! | #VALUE! | #VALUE! | #VALUE! | #VALUE! | #VALUE! | #VALUE! | #VALUE! | #VALUE! | #VALUE! | #VALUE! | #VALUE! | #VALUE! | #VALUE! |