Hi Sara
You could do this:
In A1 to E1, type formula =rand().
In A2 to E2 type =A1*100/SUM($A$1:$E$1) (where 100 is the sum of all the
random numbers you require)
This will give you the numbers whose some equals 100.


"sara" wrote:

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.