EXCEL中让单元格值在(-10,-15)或(5,10)之间随机变动,用什么函数??急!!!

2024-12-03 05:36:12
推荐回答(1个)
回答1:

输入以下公式

=CHOOSE(RANDBETWEEN(1,2),RANDBETWEEN(-15,-10),RANDBETWEEN(5,10))

 

详见附图