I'm looking for a function that allows me to distribute a value over several cells based on an U-shaped model.
For example if that value is 100 and I have 9 cells I need to assign 40% to the first cell, 40% to the last cell and the remaining 20% spread evenly between the 2nd and 8th cell.
Also, the number of cells vary for every value. For instance another value of 300 might need to be spread over 5 cells.
Hope it makes sense.