Random numbers in Numbers
Is there a way to make this formula be divisible by 5?
=RAND()×(50%−25%)+25%
iMac 27″, macOS 12.6
Is there a way to make this formula be divisible by 5?
=RAND()×(50%−25%)+25%
iMac 27″, macOS 12.6
(RAND()×(50%−25%)+25%)÷5
I believe that reduces to:
=RAND()*10%
SG
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
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%)
Random numbers in Numbers