One example is never enough: Generating a lot from a little using Excel: Part 2

When teaching or practising reading a decimal as a percentage, type =rand() into any cell, enlarge the font so it is big enough to read, and adjust to two decimal places (see Figure 1). Often it is useful in examples to have a random integer rather than a random decimal between zero and one. =rand() - gives a random number between 0 and 1 =RANDBETWEEN(90,180) - gives a random integer between 90 and 180 I explored using random numbers in the context of times tables in MT274 so you might like to read that first but I will develop this further here in the context of solving equations. Solving equations An equation can be created by combining cells containing random numbers and cells containing letters. Depending on your needs the following might help: =RANDBETWEEN(-5,12) - gives a random integer between -5 and 12 with less chance of a negative. =((-1)ARANDBETWEEN(1,2))·RANDBETWEEN (1.9) - gives a non-zero integer between nine and negative nine using the idea that (-1)1 = -1 and (-1)2 = 1. =IF(RAND()