Menu
I'm trying to use RANDBETWEEN(1,11) but omit 6 and then drag it down. I don't know how to keep excel from including 6 as a random result?
465
Returns a random integer number between the numbers you specify. A new random integer number is returned every time the worksheet is calculated.
RANDBETWEEN returns a new random value each time the worksheet is recalculated, including changes made to unrelated cells in the same workbook. To stop random numbers from changing, copy the cells that contain RANDBETWEEN to the clipboard, then use Paste Special > Values to convert to text.
maybe something like this:
=CHOOSE(RANDBETWEEN(1,2),RANDBETWEEN(1,5),RANDBETWEEN(7,11))
Try,
=choose(randbetween(1,10),1,2,3,4,5,7,8,9,10,11)
As you can see 6 is not included in the list of random numbers.
24
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With
