Ever need random numbers in MS Excel for data analysis?
Or, maybe you just need random numbers to fill cells while you work out formatting issues. You certainly don't want to sit and make up data just for that purpose. No, that takes way too much time.
Luckily, there's a much better way to fill those cells with random data and you can do it within seconds!
All you need to know is the correct formula.
=rand( ) will generate random numbers between 0 and 1.
=rand( )*10 will generate random numbers between 0 and 10.
=rand( )*100 will generate random numbers between 0 and 100.
I'm sure you get the pattern. So, now, it's just a matter of deciding the range of numbers you'd like to use.
Now that you know the formula, you just have to put it to good use!
~ April
