Forum Discussion
mcinqb3
Mar 16, 2024Copper Contributor
How to find which combination of multiples of a set of 5 numbers will return a given value
Hi all. New to excel, but decent using spreadsheets for trivial things. Right now, I'm trying to figure out which combinations of a set of 5 numbers or their multiples will give me a sum of AT LE...
peiyezhu
Mar 17, 2024Bronze Contributor
re:
So,
1922+2404+3013+3788+4755 = 15902 = Doesn't work
1922+4808 (2404*2)+3013+3788+4755 = 18306 = Works
I am afraid 18041 also works and closer to 18000
1922+3788+3788+3788+4755=18041
18041 | 41 | 1922+3788+3788+3788+4755 | 4755 | 5 | 5 |
18046 | 46 | 2404+2404+2404+2404+2404+3013+3013 | 3013 |