Excel command RANDBETWEEN() results — multiples of n only
Posted on 2016-07-23
How would you configure the Excel command, RANDBETWEEN(), to only return multiples of some number, n?
For example, if you specify
min = 100 &
max = 200,
RANDBETWEEN() will return an integer, n, for which 100 < n < 200 (or is it 100 <= n <= 200?) — not sure. But regardless, suppose you want the returned value to also be only a multiple of 5 (ie 105, 110, 115, etc)?