making random numbers, one greater than other

  • Thread starter Thread starter Navid Sami
  • Start date Start date
N

Navid Sami

1) I try to generate random numbers i A1 and B1
the numbers should be between 1 and 10 and A1 must be greater than B1
(i.e. A1>B1)


2) I try to generate random numbers i A1 and B1
their sum must be smaller than 10 (i.e. A1+B1<10)

thanks in advance
 
This in A1... =RAND()*10 ...will produce Random number <10

This in B1... =RAND()*(A1) ..will produce Random number <A1

This in C1... =MIN(RAND()*A1,RAND()*(10-A1)) ...will produce
Random number less than A1 and when summed with A1 will
be less than 10

hth
Vaya con Dios,
Chuck, CABGx3
 
Back
Top