Good evening.

In that case it might have been helpful to say what you've already tried, and in what way it didn't work.

Anyway, here's one idea.

In A1 - Total Sum Value

In A2 - Minimum Increments Value

In B1

=rand()

Copy this down for however many values you want, let's say 5, so =rand() is in every cell in B1:B5.

In C1

And copy down as far as required, in this case C1:C5.Code:=ROUND(A$1*(B1/SUM(B$1:B$5)),-LOG(A$2))

Note that this won't ALWAYS sum exactly back to the Total Sum, because of the way that the rounding works.

A crude way to correct this would be to make one of the values be a simple differential between the sum of all the other values, and the Total Sum.

## Like this thread? Share it with others