Excel Randomize Decimal Number
excel, random
Solution
Use `randbetween(70,99)` and divide the result by 10.
Problem
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... ```