excel生成随机数5，-5之间不包括0 excel生成随机数5，-5之间的整数不包括0
excel\u751f\u6210\u968f\u673a\u65705\uff0c-5\u4e4b\u95f4\u7684\u6574\u6570\u4e0d\u5305\u62ec0\u5728A1-A10\u8f93\u5165\uff1a=RAND()
\u5728B1\u8f93\u5165\uff1a=RANK(A1,A1:A10)
\u5728C1-C10\u8f93\u5165\uff1a-5\u3001-4\u3001\u2026\u2026\u30014\u30015
\u5728D1\u8f93\u5165\uff1a=INDEX(C1:C10,B1)
\u5219D1\u4e2d\u5c31\u662f\u4f60\u8981\u7684\u968f\u673a\u6570\uff0c\u800c\u4e1410\u4e2a\u503c\u53d6\u5230\u7684\u6982\u7387\u76f8\u7b49\uff0c\u5229\u7528\u7684\u662f\u968f\u673a\u6570\u6392\u540d\u7684\u539f\u7406
\u53ef\u4ee5\u6309F9\u5237\u65b0
\u5728A1-A10\u8f93\u5165\uff1a=RAND()
\u5728B1\u8f93\u5165\uff1a=RANK(A1,A1:A10)
\u5728C1-C10\u8f93\u5165\uff1a-5\u3001-4\u3001\u2026\u2026\u30014\u30015
\u5728D1\u8f93\u5165\uff1a=INDEX(C1:C10,B1)
\u5219D1\u4e2d\u5c31\u662f\u4f60\u8981\u7684\u968f\u673a\u6570\uff0c\u800c\u4e1410\u4e2a\u503c\u53d6\u5230\u7684\u6982\u7387\u76f8\u7b49\uff0c\u5229\u7528\u7684\u662f\u968f\u673a\u6570\u6392\u540d\u7684\u539f\u7406
\u53ef\u4ee5\u6309F9\u5237\u65b0
生成小数:=RAND()*5*(-1)^ROUND(RAND(),)
=RAND()*.5+1.5，生成之后用选择性粘贴（数值）使其变为普通数值。
.....这是什么A？
绛旓細濡傛灉瑕佸皬鏁扮偣鐨勮瘽灏辨槸=RAND()*(-5-5)+5锛瑕佹暣鏁扮殑璇濆氨鏄=RANDBETWEEN(-5,5)
绛旓細鍦˙1杈撳叆锛=RANK(A1,A1:A10)鍦–1-C10杈撳叆锛-5銆-4銆佲︹︺4銆5 鍦―1杈撳叆锛=INDEX(C1:C10,B1)鍒橠1涓氨鏄綘瑕佺殑闅忔満鏁帮紝鑰屼笖10涓煎彇鍒扮殑姒傜巼鐩哥瓑锛屽埄鐢ㄧ殑鏄殢鏈烘暟鎺掑悕鐨勫師鐞 鍙互鎸塅9鍒锋柊
绛旓細鐢熸垚鏁存暟锛=ROUNDUP(RAND()*5,)*(-1)^ROUND(RAND(),)鐢熸垚灏忔暟:=RAND()*5*(-1)^ROUND(RAND(),)
绛旓細1銆佹墦寮鐢佃剳涓婄殑琛ㄦ牸銆2銆佸崟鍏冩牸鍐呰緭鍏ラ殢鏈哄嚱鏁板叕寮忥細=RAND锛堬級銆3銆佺偣鍑诲洖杞﹀嵆鍙鐢熸垚涓涓闅忔満鏁板瓧锛璇ユ暟鎹殑澶у皬鑼冨洿鏃犳硶鎺у埗锛岄渶瑕佸皢鍏惰缃湪涓瀹氳寖鍥村唴銆4銆佷緥濡傞渶瑕佸皢鍏惰缃负鏁板瓧5鍒版暟瀛15涔嬮棿锛屽彲浠ヨ緭鍏ラ殢鏈哄嚱鏁帮細=RAND锛堬級*锛15-5锛+5銆5銆佺偣鍑诲洖杞︼紝鍗冲彲灏嗚緭鍏ョ殑鍏紡鐢熸垚璁＄畻缁撴灉锛屽湪涓嬪浘涓彲...
绛旓細鍦ㄥ崟鍏冩牸杈撳叆鍏紡=RANDBETWEEN(-5,5)鍚屾椂璁剧疆鍗曞厓鏍兼牸寮忎负+0;-0
绛旓細=RANDBETWEEN(5,10)涔熷彲浠ュ皢5鍜10鍒嗗埆鏀惧湪涓や釜鍗曞厓鏍间腑锛堝鏀惧湪A1鍜孊1涓級锛屽湪C1涓緭鍏=RANDBETWEEN(A1,B1)
绛旓細1銆侀鍏堟墦寮涓涓┖鐧界殑Excel鏂囨。锛屾枃妗ｄ腑娌℃湁浠讳綍鍐呭锛2銆佺劧鍚庡湪浠绘剰鍗曞厓鏍艰緭鍏ュ叕寮忥紝杩欓噷鐨凴OUND鍑芥暟鏄繚鐣欏皬鏁扮偣鐨勶紝绗竴涓弬鏁版槸鏁版嵁婧愶紝绗簩涓槸淇濈暀鐨勪綅鏁帮紱RAND鍑芥暟鏄幏鍙闅忔満鏁鐨勶紝鍚庨潰鈥*锛3-1锛+1鈥濇槸闄愬埗鍙栨暟鑼冨洿鐨勶紝3鏄渶澶ф暟锛1鏄渶灏忔暟锛屾槸鍥哄畾鍐欐硶銆傚畬鎴愪箣鍚庢寜涓嬪洖杞﹀氨鐢熸垚浜嗕竴涓...
绛旓細5. 宸х敤VBA鍜孖NDEX鍑芥暟瀵逛簬闅忔満鎺掑簭鍜岄夋嫨锛孷BA鍙互缂栧啓浠ｇ爜瀹炵幇锛屽鐢熸垚1-10鐨勬棤閲嶅闅忔満鏁銆傚姩鎬佹暟缁勬柟妗堝垯鍙互鍒╃敤SEQUENCE銆丼ORTBY銆丷ANDARRAY鍜孖NDEX鐨勫阀濡欑粍鍚锛岀敓鎴骞舵帓搴忓嚭浣犳墍闇鐨勪簲涓敮涓鏁板瓧銆傛瘮濡傦紝浣跨敤INDEX浠庢帓搴忓悗鐨勫簭鍒椾腑閫夊彇鍓浜涓紝纭繚姣忔閫夋嫨閮芥槸鐙竴鏃犱簩鐨勩傚敖绠Excel鐨勯殢鏈烘暟鏄熀浜...
绛旓細Randbetween鍑芥暟鍙細鐢熸垚闅忔満鏁存暟銆傚闇瑕侀殢鏈哄皬鏁板彲缁撳悎RAND鍑芥暟鏉ヤ娇鐢ㄣ2003鐗堜互涓婄殑Excel涓紝鐩存帴鍦ㄥ崟鍏冩牸杈撳叆=RAND锛堬級寰楀埌澶т簬绛変簬0锛屽皬浜1鐨勯殢鏈烘暟 鍏朵粬鐢熸垚鏂规硶绀轰緥锛氱敓鎴怉涓嶣涔嬮棿鐨闅忔満鏁板瓧锛圓鈮ら殢鏈烘暟<B锛夊湪绗竴涓牸瀛愪腑杈撳叆锛=RAND锛堬級*锛圔-A锛+A 濡傦紝鐢熸垚1鍒10涔嬮棿鐨闅忔満鏁板瓧锛杈撳叆锛=...
绛旓細鍦Excel涓紝瑕鐢熸垚鐗瑰畾鑼冨洿鍐呯殑闅忔満鏁帮紝浣犲彲浠ラ伒寰互涓嬫楠わ細棣栧厛锛岄夋嫨鍗曞厓鏍硷紝閿叆鍩烘湰鐨勯殢鏈烘暟鍏紡锛=RAND()銆傝繖灏嗙敓鎴愪竴涓0鍒1涔嬮棿鐨勯殢鏈哄皬鏁般傜劧鑰岋紝濡傛灉浣犻渶瑕佷竴涓叿浣撶殑鑼冨洿锛屽5鍒15锛屼綘闇瑕佺◢浣滆皟鏁淬傚湪闇瑕佺殑鑼冨洿鍐呰缃殢鏈烘暟鐨勫叕寮忔槸锛=RAND()*(15-5)+5銆傝繖閲岀殑RAND()涔樹互10锛15-5...
