Hi Sara

not aware of any way of achieving this - even using code it would be
difficult as you'ld have to "loop" it until you found an "evenly
distributed" series of numbers and then one would question the concept of
"random", especially as you're only taking about 5 numbers!

sorry

Cheers
JulieD



"sara" wrote in message
...
Hi JuliD
tried that. works fine. but sometimes cell E1 displays number that is too
large
from the rest of the cells. This is because the total is subtracted from
100.
I would prefer "evenly" distributed numbers. Are there any formulars to
do
that ?

"JulieD" wrote:

Hi

one option is in cells
A1:D1 use the formula
=RANDBETWEEN(1,20)
and in E1 use the formula
=100-SUM(A1:D1)

Cheers
JulieD

"sara" wrote in message
...
Hi.
It would help to know how I could
Fill up random numbers in say Cell A1 to E1
but the total of the random numbers should add up to say number 100
please help.