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
|