1、打开Excel,选中你想加上随机数的单元格。
![](https://video.ask-data.xyz/img.php?b=https://iknow-pic.cdn.bcebos.com/342ac65c10385343741c76279c13b07ecb8088e1?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_600%2Ch_800%2Climit_1%2Fquality%2Cq_85%2Fformat%2Cf_auto)
2、在选中的单元格里,按照此公式“=B2+RANDBETWEEN(3,11)”,选中你想加的原始数据:=B2。
![](https://video.ask-data.xyz/img.php?b=https://iknow-pic.cdn.bcebos.com/d01373f082025aafbf0e8dcdf4edab64034f1af3?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_600%2Ch_800%2Climit_1%2Fquality%2Cq_85%2Fformat%2Cf_auto)
3、随后,按照此公式“=B2+RANDBETWEEN(3,11)”,紧接输入:+RANDBETWEEN。
![](https://video.ask-data.xyz/img.php?b=https://iknow-pic.cdn.bcebos.com/d788d43f8794a4c2811f142d01f41bd5ad6e39fc?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_600%2Ch_800%2Climit_1%2Fquality%2Cq_85%2Fformat%2Cf_auto)
4、最后,按照此公式“=B2+RANDBETWEEN(3,11)”,紧接输入:(3,11)。
![](https://video.ask-data.xyz/img.php?b=https://iknow-pic.cdn.bcebos.com/242dd42a2834349b7c139d83c6ea15ce36d3be9b?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_600%2Ch_800%2Climit_1%2Fquality%2Cq_85%2Fformat%2Cf_auto)
5、公式输入完成后,点击回车键,即可得到原始数据与一个随机数据相加的结果了。
![](https://video.ask-data.xyz/img.php?b=https://iknow-pic.cdn.bcebos.com/b3119313b07eca80f181c8e19e2397dda1448334?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_600%2Ch_800%2Climit_1%2Fquality%2Cq_85%2Fformat%2Cf_auto)
6、将鼠标放在该单元格右下角,直到出现+号样式,往下拉,即可进行批量相加。
![](https://video.ask-data.xyz/img.php?b=https://iknow-pic.cdn.bcebos.com/a686c9177f3e6709208bb5f934c79f3df8dc5529?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_600%2Ch_800%2Climit_1%2Fquality%2Cq_85%2Fformat%2Cf_auto)