=RAND()*(30-1)+1下面是Excel自带的帮助:To generate a random real number between a and b, use: RAND()*(b-a)+a 就是说,a到b之间的随机数,用RAND()*(b-a)+a
RANDBETWEEN(bottom,top)用这个比较好理解=RANDBETWEEN(1,32)