excel.JPG
Hi everyone.
I want to make a random formula in G2. However, I want the selected number to be larger than the number chosen in G1. Can you teach me how to do that?
excel.JPG
Hi everyone.
I want to make a random formula in G2. However, I want the selected number to be larger than the number chosen in G1. Can you teach me how to do that?
Not enough information. Is there an upper limit to the random number? Is it always up to 20 greater than the previous number? More detail, please...
Glenn
None of us get paid for helping you... we do this for fun. So DON'T FORGET to say "Thank You" to all who have freely given some of their time to help YOU.
Temporary addition of accented to illustrate ongoing problem to the TT: L? fh?ile P?draig sona dhaoibh
In B3 then dragged across
=IFERROR(RANDBETWEEN(A3+1,99),"")
Pl note
Array formula should be confirmed with Ctrl+Shift+Enter keys together.
If answere is satisfactory press * to add reputation.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks