Can some one tell me how I can generate n number of negative exponential numbers between a gievn range...
An excel demonstration would really help.... Any one with some time to spare???
thanx in advance
Printable View
Can some one tell me how I can generate n number of negative exponential numbers between a gievn range...
An excel demonstration would really help.... Any one with some time to spare???
thanx in advance
Assuming A2 holds the low value for the range and B2 holds the hi value for the range and assuming that you want 2 to the power of the exponent:
Only problem is that rand() is called everytime a change is made to the sheet, not sure how to make it call it once per cellCode:=POWER(2,RAND()*(B2-B1)+B1)
oopps.. sorry.. i requre to generate set of n numbers which satisfy the negative exponential curve...