Does anyone know if there is a way of having a reverse sum calculate in
excel?

For example, instead of 1+1+2=4, I would like to know variations of 3 numbers that are equal to 4.
In Cell A1 I have entered a 30. I want each cell from B1 to B10 to display a number such that B1+B10 = 30

Please help me, i need to calculate hundreds of data.



thank you