QQ题集-1：如何产生6位单双相间的随机数？

Thenea

{:311:}好难，啥时公布答案？？

Aspirin.

=ODD(RAND()*7)&EVEN(RAND()*7)&ODD(RAND()*7)&EVEN(RAND()*7)&ODD(RAND()*7)&EVEN(RAND()*7)

zzmxy

不知道是不是这样的？公式比较长……

1. =--(RIGHT(INT(RAND()*9)*2+1)&RIGHT(INT(RAND()*9)*2)&RIGHT(INT(RAND()*9)*2+1)&RIGHT(INT(RAND()*9)*2)&RIGHT(INT(RAND()*9)*2+1)&RIGHT(INT(RAND()*9)*2))

复制代码

lisa6

=IF(MOD(ROW(),2),ODD(INT(RAND()*500000+500000)),EVEN(INT(RAND()*500000+500000)))

绝对冰宇

比较长：=SUM(ODD(ROUND(RAND()*9,0))*10^5,ODD(ROUND(RAND()*9,0))*10^3,ODD(ROUND(RAND()*9,0))*10,EVEN(ROUND(RAND()*8,0))*10^4,EVEN(ROUND(RAND()*8,0))*10^2,EVEN(ROUND(RAND()*8,0)))

youping1009

进来
学习  学习

yl_li

原题答案不需要使用数组结束
我的公式如下：

1. 
   
2. =SUM((RANDBETWEEN(1,{5;5;5;5;5;5})*2-{1;2;1;2;1;2})*10^(6-ROW($1:$6)))

复制代码