问题描述:
请问在EXCEL中如何让A1显示和B2随机产出的数字对应,A1,A2为1,2也就是盒号,B1为351,373是盒重
A1 A2显示盒号1和2,B1 B2随机产生盒重351,373
B1公式如下:CHOOSE(1+INT(8*RAND
()),351,373,414,417,419,427,429,452,521)
就是随机产出9个数
B2公式如下:INDEX({351,373,414,417,419,427,429,452,521},1,1+MATCH
(B10,{351,373,414,417,419,427,429,452,521})+INT(RAND()*(9-MATCH(B10,
{351,373,414,417,419,427,429,452,521}))))
就是让B2随机产生的数大于B1(反正是不相同的)
现在怎么让A单元格显示和B单元格盒重对应的盒号呢?是用IF函数吗?
A1 A2显示盒号1和2,B1 B2随机产生盒重351,373
B1公式如下:CHOOSE(1+INT(8*RAND
()),351,373,414,417,419,427,429,452,521)
就是随机产出9个数
B2公式如下:INDEX({351,373,414,417,419,427,429,452,521},1,1+MATCH
(B10,{351,373,414,417,419,427,429,452,521})+INT(RAND()*(9-MATCH(B10,
{351,373,414,417,419,427,429,452,521}))))
就是让B2随机产生的数大于B1(反正是不相同的)
现在怎么让A单元格显示和B单元格盒重对应的盒号呢?是用IF函数吗?
问题解答:
我来补答展开全文阅读