Menu
I found a very nice function in MS Excel 2007 which is RANDBETWEEN(bottom, top). The problem with this is that it randomize whole number only. Using this formula:
=RANDBETWEEN(7.0, 9.9)
yields
8.0
9.0
7.0
7.0
etc...
How can I modify it so that it will also produce decimal numbers like below
7.5
7.2
9.4
9.5
7.1
8.5
etc...
928
In this example, the RANDBETWEEN function generates random numbers between 2 and 4 with a decimal. Since it actually can't generate numbers with decimals the function generates values between 20 to 40.
Integer Decimal. Precision: digits. A random number is a number chosen from a pool of limited or unlimited numbers that has no discernible pattern for prediction. The pool of numbers is almost always independent from each other. However, the pool of numbers may follow a specific distribution.
Select a blank cell and type this formula =TEXT(ROW(A1)-1,"0000") into it, and press Enter key, then drag the autofill handle down until all the 4 digits combinations are listing.
Like RAND, Excel's RANDBETWEEN is a volatile function and it returns a new random integer every time your spreadsheet recalculates.
Use randbetween(70,99) and divide the result by 10.
144
Refer this http://ms-office.wonderhowto.com/how-to/generate-random-numbers-with-decimals-excel-338595/
Random decimal number between 30-40
=rand()*10+30
Random decimal number between 0-100
=rand()*100+0
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With
