I want to buy some assets listed below in Table A
I can buy those assets with the values from Table B
I would like a formula or vba code that can calculate the way i can do it
Table A Solution
12,40 6x2,00 - 2x0,20
12,60 6x2,00 - 3x0,20
14,10 7x2,00 - 1x0,1
14,70 7x2,00 - 1x0,50 - 1x0,20
For the first asset i would need six of two and two of 0,2 and so on..
Thanks in advance
I never knew sumproduct could be used with "--".