Home |
Search |
Today's Posts |
#10
![]() |
|||
|
|||
![]()
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 |