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

Catching RNG before getting changed?!
 

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