600000到601999中随机选五个数,用EXCEL

来源:百度知道 编辑:UC知道 时间:2024/06/16 00:16:15
600000到601999中随机选五个数,用EXCEL

不知可不可以分五个单元格显示?如果可以全部输入下面的公式就可以了.
=TRUNC(RAND()*(601999-600000)+600000,0)

如果要在同一单元格,就用&好了,若用","分隔的话,公式为:
=TRUNC(RAND()*(601999-600000)+600000,0)&","&TRUNC(RAND()*(601999-600000)+600000,0)&","&TRUNC(RAND()*(601999-600000)+600000,0)&","&TRUNC(RAND()*(601999-600000)+600000,0)&","&TRUNC(RAND()*(601999-600000)+600000,0)