Catching RNG before getting changed?!

  • Thread starter Thread starter Jo
  • Start date Start date
J

Jo

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
 
Put it in a different cell and then check that.
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
Click to expand...
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Practice Math Problems 2
I need help sorting a table 2
Why is my vbasum(F1:F45) called 46 times? 4
Generate random numberes using reference to the other cell. 7
Repeat random numbers from a range and text 5
Random function - odd error and not sure why 4
Fill down - adjust code 2
Change a column data without new row? 2

Back
Top