请问在EXCEL中如何让A1显示和B2随机产出的数字对应,A1,A2为1,2也就是盒号,B1为351,373是盒重A1 A2显示盒号1和2,B1 B2随机产生盒重351,373B1公式如下:CHOOSE(1+INT(8*RAND()),351,373,414,417,419,427,429,452,521)就是
来源:学生作业帮助网 编辑:作业帮 时间:2024/07/03 13:18:12
![请问在EXCEL中如何让A1显示和B2随机产出的数字对应,A1,A2为1,2也就是盒号,B1为351,373是盒重A1 A2显示盒号1和2,B1 B2随机产生盒重351,373B1公式如下:CHOOSE(1+INT(8*RAND()),351,373,414,417,419,427,429,452,521)就是](/uploads/image/z/1734500-20-0.jpg?t=%E8%AF%B7%E9%97%AE%E5%9C%A8EXCEL%E4%B8%AD%E5%A6%82%E4%BD%95%E8%AE%A9A1%E6%98%BE%E7%A4%BA%E5%92%8CB2%E9%9A%8F%E6%9C%BA%E4%BA%A7%E5%87%BA%E7%9A%84%E6%95%B0%E5%AD%97%E5%AF%B9%E5%BA%94%2CA1%2CA2%E4%B8%BA1%2C2%E4%B9%9F%E5%B0%B1%E6%98%AF%E7%9B%92%E5%8F%B7%2CB1%E4%B8%BA351%2C373%E6%98%AF%E7%9B%92%E9%87%8DA1+A2%E6%98%BE%E7%A4%BA%E7%9B%92%E5%8F%B71%E5%92%8C2%2CB1+B2%E9%9A%8F%E6%9C%BA%E4%BA%A7%E7%94%9F%E7%9B%92%E9%87%8D351%2C373B1%E5%85%AC%E5%BC%8F%E5%A6%82%E4%B8%8B%EF%BC%9ACHOOSE%281%2BINT%288%2ARAND%28%29%29%2C351%2C373%2C414%2C417%2C419%2C427%2C429%2C452%2C521%29%E5%B0%B1%E6%98%AF)
请问在EXCEL中如何让A1显示和B2随机产出的数字对应,A1,A2为1,2也就是盒号,B1为351,373是盒重A1 A2显示盒号1和2,B1 B2随机产生盒重351,373B1公式如下:CHOOSE(1+INT(8*RAND()),351,373,414,417,419,427,429,452,521)就是
请问在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函数吗?
请问在EXCEL中如何让A1显示和B2随机产出的数字对应,A1,A2为1,2也就是盒号,B1为351,373是盒重A1 A2显示盒号1和2,B1 B2随机产生盒重351,373B1公式如下:CHOOSE(1+INT(8*RAND()),351,373,414,417,419,427,429,452,521)就是
不知道你说的是什么意思,是不是说
盒号1对应351
盒号2对应373
盒号3对应414
...
..
盒号9对应521
是这个意思吗?
如果是的话
A1输入公式 =match(b1,{351,373,414,417,419,427,429,452,521},)
就可以了
公式下拉填充即可