Ask Me Help Desk
>
Computers & Technology
>
Software
>
Spreadsheets
> Rand between
PDA
View Full Version :
Rand between
danabides
Sep 17, 2007, 12:40 PM
is it possible to create random numbers for 7 columns, where each column has a different min and max, but each row's 7 fields will add up to hundred.
StuMegu
Sep 17, 2007, 01:45 PM
By definition all the numbers cannot be random as at least one must "correct" the total down or up to 100!