如果數(shù)據(jù)在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