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)

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

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