Using excel is there a formula, where i can a set value in one cell, and it randomly divide that number between other cells.?

using excel is there a formula, where i can a set value in one cell, and it randomly divide that number between other cells. example. cell a1 has the value 10 it randomly divides it ober cells b1,2,3,4,5 now b1=2 b2=1 b3=4 b4=0 b5=3 then each time the page updates these values will then randomly redivded... show more using excel
is there a formula, where i can a set value in one cell, and it randomly divide that number between other cells.

example. cell a1 has the value 10
it randomly divides it ober cells b1,2,3,4,5
now b1=2 b2=1 b3=4 b4=0 b5=3

then each time the page updates these values will then randomly redivded themselves again.
Update: i need the value to be completely divided randomly, so that cells b1-5 total a1 with out a smaller or exceeding total value.
2 answers 2