0-9 10个数(可重复),选5个的计算方法?

发布时间：2021-03-07 19:59:00

0-9 10个数(可重复),选5个的计算方法?

网友回答

=RANDBETWEEN(0,9)&RANDBETWEEN(0,9)&RANDBETWEEN(0,9)&RANDBETWEEN(0,9)&RANDBETWEEN(0,9)
假如首位不能是0,公式改为=RANDBETWEEN(1,9)&RANDBETWEEN(0,9)&RANDBETWEEN(0,9)&RANDBETWEEN(0,9)&RANDBETWEEN(0,9)
以上问题属网友观点，不代表本站立场，仅供参考！