WeThotUWasAToad

asked on

# Excel command RANDBETWEEN() results — multiples of n only

Hello,

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)?

Thanks

**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)?

Thanks

ASKER CERTIFIED SOLUTION

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

You may also use one of the following formulas as per your requirement....

`=CEILING(RANDBETWEEN(100,200),5)`

**OR**`=FLOOR(RANDBETWEEN(100,200),5)`

=(RANDBETWEEN(100/5,200/5)) * 5

It appears that it's 100 <= n <= 200 (as confirmed by testing)

From Excel Help:

The RANDBETWEEN function syntax has the following arguments:

Bottom Required. The smallest integer RANDBETWEEN will return.

Top Required. The largest integer RANDBETWEEN will return.

"Will return" is the key here....

From Excel Help:

The RANDBETWEEN function syntax has the following arguments:

Bottom Required. The smallest integer RANDBETWEEN will return.

Top Required. The largest integer RANDBETWEEN will return.

"Will return" is the key here....

ASKER

Thank you for the several and varied responses. There are

Best solution to

Thanks again

*indeed*many ways to skin a cat.Best solution to

**Subodh Tiwari (Neeraj)**was chosen based on simplicity. Honorable mention to**wsh2**for the*cleverest*solution and extra thanks to**Fred Marshall**for looking up something I could/should have taken 30 seconds to look up on my own. :PThanks again

100+int((200-100)*rand()/5