Excel中随机生成函数方法大全视界嗨盗王?2018-03-1218:42:54（一）生成0到9的随机整数方法一：=INT(RAND()
(10-0))+0方法二：=RANDBETWEEN(0,9)方法三：=ROUND(RAND()9,0)方法四：=CHAR(48+
RAND()10)方法五：=CHAR(RANDBETWEEN(48,57))（二）生成大写英文字母方法一：=CHAR(65+RA
ND()26)方法二：=CHAR(RANDBETWEEN(65,90))（三）生成小写英文字母方法一：=CHAR(RANDBET
WEEN(97,122))方法二：=CHAR(97+RAND()26)（四）数字，字母随机混合生成方法一：=CHAR(CHOOS
E(1+RAND()3,48+RAND()10,65+RAND()26,97+RAND()26))方法二：=CHAR(CH
OOSE(RANDBETWEEN(1,3),RANDBETWEEN(48,57),RANDBETWEEN(65,90),RANDB
ETWEEN(97,122))) |
|
