K Kiru New Member Oct 20, 2016 #1 Hi, Please help as i the following 50 25 10 i would like to know how many combinations i can get to make a hundred eg. 50 1 1 1 2 0 0 0 0 0 25 1 2 0 0 1 2 0 0 0 10 2 0 5 0 7 5 10 9 8 95 100 100 100 95 100 100 90 80
Hi, Please help as i the following 50 25 10 i would like to know how many combinations i can get to make a hundred eg. 50 1 1 1 2 0 0 0 0 0 25 1 2 0 0 1 2 0 0 0 10 2 0 5 0 7 5 10 9 8 95 100 100 100 95 100 100 90 80
K Kiru New Member Oct 20, 2016 #3 vletm said: Is there any logic with You missed combinations? Click to expand... hi, So this is what i am trying to achieve but in an excel formula: If i have the numbers 50, 25,10, then 50*2 = 100, but it could also be 50 +(25*2) or 50+(10*5) etc. Thank you
vletm said: Is there any logic with You missed combinations? Click to expand... hi, So this is what i am trying to achieve but in an excel formula: If i have the numbers 50, 25,10, then 50*2 = 100, but it could also be 50 +(25*2) or 50+(10*5) etc. Thank you
K Kiru New Member Oct 20, 2016 #4 Please see attached file. I worked it out manually wants to know if it can be automated with a formula Attachments Book1.xlsx Book1.xlsx 8.5 KB · Views: 4
Please see attached file. I worked it out manually wants to know if it can be automated with a formula
V vletm Excel Ninja Oct 20, 2016 #5 Is there any logic with You missed combinations? like range("B8:L11"), where do those values comes?
K Kiru New Member Oct 20, 2016 #6 hi Vletm, I manually inputted those figures to try and check the possible combinations to get to 100 Regards Kiru
hi Vletm, I manually inputted those figures to try and check the possible combinations to get to 100 Regards Kiru
