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

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

人气：293 ℃　时间：2020-03-25 13:41:50

解答

=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)...