I want to create a subtraction math mad minute sheet (about 60 questions) for my students. The first version has to have no negative numbers. Easy enough to do with RANDBETWEEN if the target definition cells contain a min (eg 0) and a max (eg 9). The problem is that RANDBETWEEN is a uniform distribution so I'm going to see as many 1s (for example) as I will 9s. 1s can only have 2 possible outcomes ( 1-1=0 and 1-0=1) but a 9 can have 10 outcomes. The result is a "boring" sheet with way too many low numbers and not enough high numbers. So in 55 "random" rolls, how can I get 10 9s, 9 8s, .......2 1s, and 1 0? I'd prefer to just specify a max value in a cell as opposed to something like using macros.
SGP
SGP