首先需要启用迭代计算 ,Excel 选项 --公式 --启用迭代运算 次数可以多设一点,比如30000次
A1 输入公式:
=IF(SUM(A$1:A$7)=20,A1,RANDBETWEEN(1,2000)/100)
公式下拉 , 生成的是 静态的 随机结果
需要重新生成 重新下拉
![](https://video.ask-data.xyz/img.php?b=https://iknow-pic.cdn.bcebos.com/5882b2b7d0a20cf44a8d27b47c094b36acaf99b8?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_600%2Ch_800%2Climit_1%2Fquality%2Cq_85%2Fformat%2Cf_auto)
![](https://video.ask-data.xyz/img.php?b=https://iknow-pic.cdn.bcebos.com/d53f8794a4c27d1e0e79e2af11d5ad6eddc4387a?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_600%2Ch_800%2Climit_1%2Fquality%2Cq_85%2Fformat%2Cf_auto)
追问![](https://video.ask-data.xyz/img.php?b=https://iknow-pic.cdn.bcebos.com/f11f3a292df5e0fe0d68466a566034a85edf726d?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_600%2Ch_800%2Climit_1%2Fquality%2Cq_85%2Fformat%2Cf_auto)
我怎么用着总数大于20了啊?
追答你次数设少了, 它没算完, 按 F9 继续算
追问没懂起!!!!
追答不是说过设置迭代 次数为30000次么, 你设置了多少次
追问恩!我刚刚改了 还是不行啊
![](https://video.ask-data.xyz/img.php?b=https://iknow-pic.cdn.bcebos.com/8d5494eef01f3a2953e9eea29325bc315c607cbc?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_600%2Ch_800%2Climit_1%2Fquality%2Cq_85%2Fformat%2Cf_auto)
追答那就 按 F9 按F9 按F9
本回答被网友采纳