- Worldstart's Tech Tips And Computer Help - http://www.worldstart.com -

Randomness in MS Excel

Posted By On April 14, 2006 @ 1:51 PM In MS Excel,MS Office Help | No Comments

Randomness in MS Excel

Ever need random numbers in 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 for this purpose. That takes way too much time.

You just know there is and I can definitely say that you’re correct. There is a much better way to fill those cells with random data within seconds.

So, sounds like all we 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.

Well, I’m sure you get the pattern, so 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


Article printed from Worldstart's Tech Tips And Computer Help: http://www.worldstart.com

URL to article: http://www.worldstart.com/randomness-in-ms-excel/