Posted to microsoft.public.excel.programming

Jo[_2_]

external usenet poster

Posts: 69

Catching RNG before getting changed?!

Hi,

In one cell, I have: =if(randbetween(1,10)<5,randbetween(1,10),0)

But I soon recognized is that the 1st randbetween not necessarily same
as the 2nd one?!

How can I make sure that both randbetween values are identical?

Thanks,
Jo

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Catching an error	ChrisMattock[_29_]	Excel Programming	8	July 4th 06 10:15 AM
Catching text from a Control.	[email protected]	Excel Programming	4	May 17th 06 09:55 PM
Catching errors	cbh35711[_10_]	Excel Programming	0	April 3rd 06 09:52 PM
Catching VbMsgBoxResult	jose luis	Excel Programming	2	October 31st 04 06:43 AM
Catching an error	Shannon	Excel Programming	1	December 8th 03 08:22 PM

All times are GMT +1. The time now is 12:32 AM.

About Us

"It's about Microsoft Excel"

Menu

About Us