Catching RNG before getting changed?!

's Computer Specifications

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

's Computer Specifications

Put it in a different cell and then check that.

Jo wrote:
>
> 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

--

Dave Peterson

Thread Tools
Show Printable Version Email this Page
Rate This Thread
Rate This Thread:

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Changed monitor also changed position of Window Mail Send/Receivewindow	TomYoung	Windows Vista Mail	2	5th Sep 2008 03:28 AM
TURNED ON MY COMPUTER AND FONT SIZE SETTINGS CHANGED TO TINY/EXCELL CHANGED TOO	ptobinPR@gmail.com	Microsoft Outlook	0	29th Oct 2006 09:50 PM
POP3 Server is changed to Localhost and the login name changed to username\POP3server!	Thinky	Microsoft Outlook	3	19th Apr 2006 08:55 PM
changed web hosting co; Changed FP2002 user id/password not working	stephanie	Microsoft Frontpage	9	28th May 2004 04:49 AM
Catching an Event for Changed Value in DataView or Dataset?	Lars Netzel	Microsoft VB .NET	0	7th May 2004 11:20 AM