Ok, so I don’t know if this is possible at all, but i’ll ask the question and let’s see:
I would like to make some automatic calculations:
From a arbitrary number, I need to find the best combination of other, pre-defined, numbers, as close to the arbitrary number as possible.
My aim is to manually update one column with an arbitrary number, then make Excel calculate and fill the best combination of the pre-defined numbers.
Pre-defined numbers are 350, 500, 700, 1000.
Examples:
If the arbitrary number is 865 - then I want to automatically calculate that 1x350 and 1x500 is the best combination. And rhen automatically, 1 goes in the column for 350 and 1 goes in the column for 500
If the arbitrary number is 1412, I want the combination to be 2x700. 2 goes in the column for 700.
And so on.
I have no idea at all if thhos could be done. All help is appreciated!
Screenshot for explanation, numbers are manually entered:
Namnlös.png
Bookmarks