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