Dec 24 2021 09:28 PM
For example I have number 51, I want to divide it into 4 intervals.
In column A the interval is 1 - 5
In column B the interval is 6 - 12
In column C the interval is 13 - 20
In column D the interval is 21 or more
So 51 would be
Column A is 5
Column B is 7
Column C is 8
Column D is 31
How to do it with function for each column?
Dec 24 2021 11:24 PM
Are you trying to find all possible combinations of 4 numbers from different intervals that add up to a certain other number? In your example there would only be one solution, namely: 1+6+13+21=51
What logic did you apply to select the number 8 for column C where the interval is set to 13-20?
Or perhaps you want to achieve something completely different.