CodePudding user response:
According to the demand of the first half of the sentence can realize=1 + RAND () * (10-1)
But after half sentence seems to demand conditions, there is no limit to complete the number between 1 to 5 important premise is that it may not be less than 80% of the random Numbers produced a total of how many, and may not be able to achieve an expression, may need to vba, see you there is no better way