Simple Excel function that splits a numbered entered into one cell randomy and evenly over 3 others.
- by Mike
Hi all,
I am looking for a simple function that will take a number entered into a single cell say 20 and divide it evenly and randomly over three other cells, none of the values can be 0.
ie. A1 = 20
then
B1=6
C1=8
D1=6
Thanks!!