如何使两个随机数相除没有余数 (10261)


B1:F10{=SUBSTITUTE(TEXT(SMALL(IF(MOD(ROW($2:$99)/COLUMN(C:AX),1)=0,ROW($2:$99)/1%+COLUMN(C:AX)),RANDBETWEEN(1,COUNT(0/(MOD(ROW($2:$99)/COLUMN(C:AX),1)=0)))),"0!÷00"),"÷0","÷")&"="


留言