View Single Post
  #10   Report Post  
ramana
 
Posts: n/a
Default

Hi Joeu,

In atrial and error method accidentally I got the solution to
generate real random numbers with the randbetween function.

What I did to solve this problem is.

A1: =RAND()*(50-40)+40
B1:
=RANDBETWEEN(MAX(35000,83000-A1*1000),MIN(45000,88000-A1*1000))/1000
C1: =A1+B1


The above is working well and solved my problem Once agai I thank
Jeou&Max for your interest and the solution given by youpeople. which
made my work easier.

Thanks a lot...

Ramana