EXCL随机数问题,谁给编一个0.013到0.015之间的正负随机数?在线等 excl中随机数怎么整
excl\u4e2d\u8bbe\u7f6e\u4e00\u7ec4\u968f\u673a\u6570\u4f8b\u5982\u968f\u5373\u5f97\u5230\u6570\u503c\u662f\uff0827\uff0c24\uff0c29\uff09\u600e\u6837\u8bbe\u7f6e\u4f7f\u8fd9\u4e09\u4e2a\u968f\u673a\u6570\u4e4b\u95f4\u7684\u504f\u5dee\u57285\u4e4b\u95f4\u3002\u5982\u679c\u6ca1\u6709\u5176\u4ed6\u9650\u5236\uff0c\u90a3\u7b2c\u4e00\u4e2a\u6570\u5b57\u968f\u673a\uff0c\u540e\u9762\u7684\u5728\u8fd9\u4e2a\u6570\u5b57\u57fa\u7840\u4e0a\u52a0\u4e0a\u6216\u51cf\u53bb\u4e00\u4e2a\u5c0f\u4e8e5\u7684\u968f\u673a\u6570\u5c31\u884c\u4e86
\u4e0d\u77e5\u9053\uff0c\u968f\u673a\u6574\u554a
在表格内输入=(RAND()*(0.015-0.013)+0.013)*IF(RAND()>0.5,1,-1) 需要出现5位数的就在表格右键--设置单元格格式--数字--数值--小数位数 那里设置绛旓細绀轰緥 鍋囪鎴戜滑闇瑕佺敓鎴10涓0鍒100涔嬮棿鐨勪笉閲嶅闅忔満鏁锛1. 鍦ˋ1鍒癆10杈撳叆1鍒10銆2. 鍦˙1鍒癇10杈撳叆 `=RAND()`銆3. 閫夋嫨A鍒楀拰B鍒楋紝鎸夆滄暟鎹->鈥滄帓搴忊->鎸塀鍒楁帓搴忋4. 鎺掑簭鍚嶢鍒楃殑鏁版嵁鍗充负0鍒100涔嬮棿鐨勪笉閲嶅闅忔満鏁般傞氳繃涓婅堪鏂规硶锛屾偍鍙互鍦Excel涓殢鏈鐢熸垚鍚勭鏁板瓧缁勫悎銆
绛旓細濡傛灉浣犳槸闇瑕0-100鐨勬暣鏁帮紝閫変腑浣犺鐢熸垚鐨勫尯鍩燂紝鐒跺悗杈撳叆濡備笅鍑芥暟 =INT(RAND()*100)鎸夐敭鐩楥TRL+SHIFT+ENTER涓変釜閿疄鐜版暟缁勫叕寮忕殑杈撳叆銆傚鏋滀綘闇瑕佸甫灏忔暟锛岀敤濡備笅鍑芥暟 =RAND()*100 杈撳叆鍚庡悓鏍锋寜閿洏CTRL+SHIFT+ENTER涓変釜閿
绛旓細A1鍗曞厓鏍煎啓鍏 12:10:01 A2鍗曞厓鏍煎啓鍏ュ叕寮 =A1+RAND()*4/86400+80/86400 鍐嶈缃崟鍏冩牸鏍煎紡涓 鏃堕棿 13:30:55 鏍煎紡 鎴 =TIME(HOUR(A1),MINUTE(A1),SECOND(A1)+RAND()*5+80) 鍐嶈缃崟鍏冩牸鏍煎紡涓 鏃堕棿 13:30:55 鏍煎紡 =TEXT(A1+RAND()*4/86400+80/86400,"h:mm:ss...
绛旓細2. 浣跨敤RAND()鍑芥暟鐢熸垚3涓闅忔満鏁锛氬湪Excel涓紝浣跨敤RAND()鍑芥暟鍙互鐢熸垚0鍒1涔嬮棿鐨勯殢鏈烘暟銆傚洜姝わ紝鍙互鍦‥xcel涓娇鐢≧AND()鍑芥暟鐢熸垚3涓殢鏈烘暟銆3. 灏嗛殢鏈烘暟涔樹互骞冲潎鍊硷細灏嗙敓鎴愮殑涓変釜闅忔満鏁板垎鍒箻浠ユ楠1涓绠楀嚭鐨勬瘡涓殢鏈烘暟鐨勭悊璁哄钩鍧囧硷紝寰楀埌涓変釜闅忔満鏁般傞氳繃浠ヤ笂姝ラ锛屽氨鍙互灏涓涓鏁板垎鎴3涓殢鏈烘暟...
绛旓細鍚敤杩唬璁$畻 鍚 鐢闅忔満鍏紡:
绛旓細鍦ㄤ綘瑕佺敓鎴闅忔満鏁鐨勫崟鍏冩牸杈撳叆 =RANDBETWEEN(1,10)&" "&RANDBETWEEN(1,10)&" "&RANDBETWEEN(1,10)杩欐牱浼氳嚜鍔ㄧ敓鎴3涓互绌烘牸闅斿紑鐨勯殢鏈烘暟銆傛垨鑰呰緭鍏 =RANDBETWEEN(1,10)&"-"&RANDBETWEEN(1,10)&"-"&RANDBETWEEN(1,10)杩欐牱浼氳嚜鍔ㄧ敓鎴3涓互鈥-鈥濋殧寮鐨勯殢鏈烘暟銆
绛旓細=rand()鐢熸垚0-1涔嬮棿鐨勯殢鏈烘暟锛堝皬鏁帮紝鍖呭惈0涓嶅寘鍚1锛=Randbetween(1,10)鐢熸垚1-10涔嬮棿锛堝寘鍚1鍜10锛屾暟瀛楀彲浠ヨ嚜宸变慨鏀逛负鑷繁瑕佺殑鑼冨洿锛夌殑闅忔満鏁帮紙鏁存暟锛夈傛嫇灞曟濊矾锛=RAND()*100 澶т簬绛変簬0浣嗗皬浜100鐨涓涓殢鏈烘暟锛堝甫灏忔暟锛
绛旓細=int(rand()*10)
绛旓細1銆佺敤randbetween鍑芥暟鐢熶骇涓涓鑼冨洿鍐呯殑闅忔満鏁板兼暣鏁伴儴鍒嗭紝鍏紡锛=RANDBETWEEN(鏈灏忓,鏈澶у)锛2銆佺敤rand鍑芥暟鐢熶骇闅忔満鏁板瓧锛堝皬鏁伴儴鍒嗭級锛屽叕寮=RAND()锛3銆佺敤round鍑芥暟澶勭悊灏忔暟鐐逛綅鏁帮紝鍏紡=round(鏁板,淇濈暀灏忔暟鐐瑰悗鍑犱綅鏈夋晥鏁帮級4銆佷妇渚嬶細鍋囪鐢熸垚0鍒100涔嬮棿鐨闅忔満鏁帮紝淇濈暀灏忔暟鐐瑰悗2浣嶆湁鏁堟暟銆傛暣涓叕寮...