For example, to generate a random number between 0 and 100, you would use =RAND () * 100. Similarly, if you need a random number between two specific values, say 10 and 50, the formula below will ...