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

Posted on Sep 25, 2023 6:47 PM

Reply
4 replies

Sep 25, 2023 7:45 PM in response to SGIII

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

Random numbers in Numbers

Welcome to Apple Support Community
A forum where Apple customers help each other with their products. Get started with your Apple ID.