How to fill a cell with random numbers to do calculations?

zanat0s · #1 06-13-2011, 06:21 AM

Hi all,

i want to do a simulation and therefore i need to give fictional numbers within a range.

so lets say i need to fill 100 cells with a normal distribution where the Min i 10.000 and the max 10.000

or can i use something else

lets say 40% that the number is smaller than 15.000 and 60% that it is higher?

OTPM · #2 06-13-2011, 10:33 AM

Hi
You could try the =RANDBETWEEN() function. This may give you what you are after.
Tony (OTPM)

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Display Random Numbers as Transition	greenbutton	PowerPoint	0	03-09-2011 04:43 PM
adding numbers in same cell	jetdude68	Word Tables	1	07-20-2010 12:30 AM
How can I fill cell color starting from Cell D5 using Conditional formatting instead	Learner7	Excel	0	07-08-2010 05:50 AM
Can I do calculations with times?	cubsfan_1	Excel	1	01-14-2010 06:55 PM
Having problems with Duration calculations.	bgane	Project	1	03-20-2006 06:36 AM