# 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.

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.

Follow

2 answers
2

Are you sure that you want to delete this answer?