如何在excel一个单元格内取4个随机数,用逗号隔开

2026-05-19 19:56:48
推荐回答(2个)
回答1:

随机整数吗?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)

回答2:

=INT(RAND()*3)&","&INT(RAND()*3)&","&INT(RAND()*3)&","&INT(RAND()*3)