随机整数吗?2以内也就是0、1、2
=RANDBETWEEN(0,2)&","&RANDBETWEEN(0,2)&","&RANDBETWEEN(0,2)&","&RANDBETWEEN(0,2)
或者:
=INT(RAND()*3)&","&INT(RAND()*3)&","&INT(RAND()*3)&","&INT(RAND()*3)
如果是随机小数,则需要指定位数,用TRUNC截尾函数:
=TRUNC(RAND()*3,2)&","&TRUNC(RAND()*3,2)&","&TRUNC(RAND()*3,2)&","&TRUNC(RAND()*3,2)
=INT(RAND()*3)&","&INT(RAND()*3)&","&INT(RAND()*3)&","&INT(RAND()*3)