wps表格怎么随机生成1000-3500的随机数学
在任一单元格内输入或复制粘贴下列公式=RANDBETWEEN(1000,3500)
下拉填充,右拉填充
绛旓細1銆佹墦寮wpsword鏂囨。锛岄変腑闇瑕佹彃鍏ュ簭鍙风殑琛ㄦ牸鍖哄煙锛1000-2000锛夛紝鐐瑰嚮涓婃柟鐨勭紪鍙峰浘鏍.2銆佸湪鍒楄〃涓偣鍑讳笅鏂圭殑鑷畾涔夌紪鍙枫3銆侀変腑缂栧彿鐨勬牱寮忓悗锛岀偣鍑昏嚜瀹氫箟銆4銆佸湪缂栧彿鏍煎紡涓嬶紝灏嗘暟瀛楀悗闈㈢殑.鍘婚櫎锛岀偣鍑荤‘瀹氥5銆佸嵆鍙湪word涓揩閫熸彃鍏ュ簭鍙枫
绛旓細涓嬫媺濉厖锛屽彸鎷夊~鍏
绛旓細鎺ョ潃锛屾垜浠夋嫨"姝ラ暱"閫夐」锛屽苟灏嗘闀胯缃负1锛岃繖鏍峰氨鍙互鐢熸垚涓涓粠璧峰鍊煎埌缁撴潫鍊肩殑杩炵画搴忓垪銆傛渶鍚庯紝鐐瑰嚮"纭畾"鎸夐挳锛wpsexcel浼氳嚜鍔ㄥ皢閫夊畾鐨勫崟鍏冩牸鑼冨洿濉厖涓婅繛缁簭鍒楋紝浠庤屽疄鐜颁笅鎷夐夋嫨1000鐨勬晥鏋溿1.棣栧厛閫変腑闇瑕佽瀹氫笅鎷夐夐」鐨勫崟鍏冩牸锛屼箣鍚庣偣鍑荤晫闈笂鏂硅彍鍗曚腑鐨勩愭暟鎹戯紝闅忓悗鐐瑰嚮鍔熻兘鏍忎腑鐨勩愭湁鏁堟...
绛旓細姣斿闇瑕 1-10涔嬮棿鐨 2浣嶅皬鏁帮紝灏辩敤锛=RANDBETWEEN(100,1000)/100
绛旓細鍦╓PS琛ㄦ牸涓鎬庢牱鐢熸垚1鑷100鐨闅忔満涓や綅灏忔暟 閭d箞瀹為檯涓婅繖涓暟婊¤冻9<X<100 鍙互浣跨敤鍑芥暟RANDBETWEEN锛屽叕寮忓鍥炬墍绀 =RANDBETWEEN(10,99)瑕佹眰鏄2浣嶅皬鏁帮紝閭d箞鎸夌収鍒氭墠鎵鍋氱殑鍏紡锛屾垜浠彧瑕佺◢浣滀慨鏀瑰氨鍙互锛屾垜浠彲浠ュ厛鍙樻垚4浣嶆暣鏁帮紝鍐嶉櫎浠100 鎵浠ュ叕寮忓氨鍙樻垚浜嗭細=RANDBETWEEN(1000,9999)/100 杩欓噷鍐嶄粙缁嶄竴涓...
绛旓細=1000&RANDBETWEEN(10000000000000,99999999999999)&RANDBETWEEN(10^13,10^14-1)澶嶅埗骞朵笅鎷夊嵆鍙
绛旓細wps蹇熷鍒1000琛岀殑鏂瑰紡濡備笅锛氶鍏堟墦寮鎴栨柊寤鸿缂栬緫鐨琛ㄦ牸锛岀劧鍚庨紶鏍囩Щ鑷宠澶嶅埗鍐呭鐨勬渶鏈竴琛岋紝鍗曞嚮榧犳爣骞堕変腑姝ゅ崟鍏冩牸锛屾渶鍚庝娇榧犳爣鐨勬寚閽堝彉鎴愰粦鑹插疄蹇冪嚎鍔犲舰鐘舵椂锛岃繘琛屾嫋鍔ㄥ嵆鍙倃ps鍦ㄤ繚璇佸姛鑳藉畬鏁存х殑鍚屾椂锛岃繕淇濇寔杈冨悓绫昏蒋浠朵綋绉渶灏忕殑鐗圭偣锛屼笅杞藉拰瀹夎鏇村姞蹇熶究鎹凤紝涓虹敤鎴锋彁渚涗簡鑹ソ鐨勪綋楠屻
绛旓細=RANDBETWEEN(A1*1000*0.98,A1*1000*1.02)/1000
绛旓細棣栧厛锛wps琛ㄦ牸涓渶瑕佷竴绉嶆墽琛屽姞鍑忕殑绋嬪簭锛屾墍浠ヤ綘闇瑕 鐐瑰嚮锛氣滃紑濮嬧濈殑鏈鍙宠竟鏈変竴涓嚜鍔ㄦ眰鍜岋紝鐒跺悗鍦ㄦ嫭鍙峰唴 杈撳叆锛7000-6000 鍥炶溅锛岃嚜鍔ㄨ绠楃粨鏋
绛旓細宸ュ叿锛忓師鏂欙細鐢佃剳銆wps 1銆佸疄闄呮搷浣滄椂锛屾垜浠彲浠ヨ鈥滅函鏁板瓧鈥濊嚜鍔ㄩ掑锛屼篃鍙互璁╁惈鈥滄枃鏈紜鏁板瓧鈥濅腑鐨勮嚜鍔ㄩ掑鎴栨暟瀛椾笉鍙橈紝濡備笅鍥炬墍绀猴細2銆侀紶鏍囩Щ鑷抽渶瑕佸鍒剁殑鍗曞厓鏍硷紝鍗曞嚮榧犳爣宸﹂敭锛岄夊畾鍗曞厓鏍硷紝濡備笅鍥炬墍绀猴細3銆侀紶鏍囩Щ鑷抽夊畾鍗曞厓鏍肩殑鍙充笅瑙掞紝璁╅紶鏍囨寚閽堝彉涓洪粦鑹茬殑鈥滐紜鈥濓紝濡備笅鍥炬墍绀轰綅缃锛4銆...