Happy New year to everyone!
I have a bit of a problem and I was hoping someone could help. The thing is that I am using a formula but I need to add a way that allows the result to be a number that is always either the same or less than the other.
I am using this formula in the cell H3
=IF($C$10=1,RANDBETWEEN(1,9),IF($C$10=2,RANDBETWEEN(10,99),IF($C$10=3,RANDBETWEEN(100,999),IF($C$10=4,RANDBETWEEN(1000,9999),RANDBETWEEN(10000,99999)))))
This formula generates a random number between the numbers in parenthesis which I want to do , but I also need a formula to put in cell J8 that does the same thing plus return any of those numbers either the same or less than the number in H3.
I am trying to do is to create a worksheet with division problems so when I put that formula in H3 generates a number and to put a formula in J8 that does the same thing but that generates a number that is less than the one generated in H3. I have no idea as to how to do that.
In short, if H3 gives me a 7 then J8 gives me a 7 or any number less than 7.
Any help would be greatly appreciated.
Liz
Bookmarks