如果數據在A2單元格,那么輸入以下公式
=RANDBETWEEN(INT(A2*1000)-10,INT(A2*1000)+10)/1000
或者直接輸入
=RANDBETWEEN(102347116,102347134)/1000
=RANDBETWEEN(INT(A2*1000)-10,INT(A2*1000)+10)/1000
或者直接輸入
=RANDBETWEEN(102347116,102347134)/1000