excel 写个以数字和字母组合且不重复的三位数取值答:=CHAR(IF(MOD(INT(RAND()*1000),2),RANDBETWEEN(48,57),RANDBETWEEN(65,90)))&CHAR(IF(MOD(INT(RAND()*1000),2),RANDBETWEEN(48,57),RANDBETWEEN(65,90)))&CHAR(IF(MOD(INT(RAND()*1000),2),RANDBETWEEN(48,57),RANDBETWEEN(65,90)))如果要排除数字0和字母O,公式改为:=CHAR(IF(...