随机得到两数之间的整数公式:=int(rand()*(最大数-最小数+1))+最小数你这里要的公式应该为:=int(rand()*(500-1+1))+1
=randbetween(1,500)该函数需要加载宏。
=randbetween(1,500) =INT(RAND()*500+1)
=ROUND(RAND()*500,0)
int(500*rand())
