Random numbers in Numbers

The formula RAND()×(50%−25%)+25% is the same as (1+RAND())*25%.

If you want to round it to the nearest 5%,

=MROUND((1+RAND())*25%,5%)

Possibly. But, it also depends on the intention of the poster.

Eg. Replace the random function with some number. I'll use 100

So, we get 100 * 25% = 25

Plus 25% of the resultant = 31.25

divided by 5 = 6.25

But, they might also mean:

100 * 25% = 25

Plus 25% of the random number = 25+25 = 50

divided by 5 = 10

(RAND()×(50%−25%)+25%)÷5

I believe that reduces to:

=RAND()*10%

SG