EXCEL中围绕一个数值在一定范围内产生随机数，例如：我要在数值为-70,在正负5之内波动的随机数。 如何在excel中生成一个在一定范围内的随机数
EXCEL\u4e2d\u56f4\u7ed5\u4e00\u4e2a\u6570\u503c\u5728\u4e00\u5b9a\u8303\u56f4\u5185\u4ea7\u751f\u968f\u673a\u6570\uff0c\u4f8b\u5982\uff1a\u6211\u8981\u5728\u6570\u503c\u4e3a2.860,\u5728\u6b63\u8d1f0.005\u4e4b\u5185\u6ce2\u52a8\u7684\u968f\u673a\u6570\uff1f\u6709\u91cd\u590d\u7684\u516c\u5f0f
=RANDBETWEEN(2855,2865)/1000
\u65e0\u91cd\u590dVBA\u5904\u7406
Excel\u5217\u4e3e\u4e24\u4e2a\u6574\u6570\u95f4\u4e0d\u91cd\u590d\u968f\u673a\u6570
\u8fd0\u884c\u5b8f\uff0c\u8f93\u51652855,2865\uff0c\u751f\u6210\u6570\u636e
\u5176\u5b83\u5355\u5143\u683c\u8f93\u51651000\uff0c\u590d\u5236\uff0c\u9009\u62e9\u7c98\u8d34\u5230\u4e0a\u9762\u6570\u636e\uff0c\u9009\u9664\u3002\u751f\u6210\u7ed3\u679c\u3002
1\u3001\u9996\u5148\u5728excel\u8868\u683c\u7684\u5355\u5143\u683c\u5185\u8f93\u5165\u968f\u673a\u51fd\u6570\u516c\u5f0f\uff1a=RAND()\u3002
2\u3001\u70b9\u51fb\u56de\u8f66\u5373\u53ef\u751f\u6210\u4e00\u4e2a\u968f\u673a\u6570\u5b57\uff0c\u8be5\u6570\u636e\u7684\u5927\u5c0f\u8303\u56f4\u65e0\u6cd5\u63a7\u5236\uff0c\u9700\u8981\u5c06\u5176\u8bbe\u7f6e\u5728\u4e00\u5b9a\u8303\u56f4\u5185\u3002
3\u3001\u4f8b\u5982\u9700\u8981\u5c06\u5176\u8bbe\u7f6e\u4e3a\u6570\u5b575\u5230\u6570\u5b5715\u4e4b\u95f4\uff0c\u53ef\u4ee5\u8f93\u5165\u968f\u673a\u51fd\u6570\uff1a=RAND()*(15-5)+5\u3002
4\u3001\u70b9\u51fb\u56de\u8f66\uff0c\u5373\u53ef\u5c06\u8f93\u5165\u7684\u516c\u5f0f\u751f\u6210\u8ba1\u7b97\u7ed3\u679c\uff0c\u5728\u4e0b\u56fe\u4e2d\u53ef\u4ee5\u770b\u5230\u751f\u6210\u7684\u968f\u673a\u6570\u636e\u5c31\u57285\u523015\u4e4b\u95f4\u4e86\u3002
=RANGBETWEEN(0,10)+65
函数：
=RANDBETWEEN(-75,-65)
绛旓細=RANGBETWEEN(70-5,70+5)=RANGBETWEEN(0,10)+65
绛旓細杩愯瀹忥紝杈撳叆2855,2865锛岀敓鎴鏁版嵁 鍏跺畠鍗曞厓鏍艰緭鍏1000锛屽鍒讹紝閫夋嫨绮樿创鍒颁笂闈㈡暟鎹紝閫夐櫎銆傜敓鎴愮粨鏋溿
绛旓細1銆excel涓A1澶т簬14涓斿皬浜20锛屽彲浠ヤ娇鐢ˋND鍑芥暟琛ㄧず锛屽叕寮忎负锛=AND(A1>14,A1<20)銆2銆佺偣鍑诲洖杞﹀彲浠ョ湅鍒版鏃跺崟鍏冩牸涓樉绀轰负false锛岃〃绀哄崟鍏冩牸涓殑鏁版嵁娌℃湁婊¤冻鍏紡鐨勬潯浠躲3銆佹垨鑰呭彲浠ヤ娇鐢ㄥ叕寮忥細=(A1>14)*(A1<20)锛屽鏋滄病鏈夋弧瓒虫潯浠跺垯浼氭樉绀衡0鈥濄4銆佸鏋滈渶瑕佽〃绀虹瓑浜庡叧浜庯紝姣斿A1=14 鎴栬 A1=2...
绛旓細1銆佸湪绌虹櫧鍗曞厓鏍间腑杈撳叆闅忔満鍑芥暟鍏紡=RAND()锛屽嵆鍙緱鍒涓涓闅忔満鏁板銆2銆佸鏋滈渶瑕佸皢鍏惰缃负鏁板瓧2鍒版暟瀛10涔嬮棿闅忔満鍔犲噺锛屽彲浠ヨ緭鍏ラ殢鏈哄嚱鏁帮細=RAND()*(10-2)+2銆3銆佺偣鍑诲洖杞︼紝鍗冲彲灏嗚緭鍏鐨鍏紡鐢熸垚璁＄畻缁撴灉锛屽湪涓嬪浘涓彲浠ョ湅鍒扮敓鎴愮殑闅忔満鏁版嵁灏卞湪2鍒10涔嬮棿浜嗐4銆佸弻鍑诲叕寮忓崟鍏冩牸鍐嶇敓鎴愮粨鏋滐紝鍙互鐪嬪埌姝ゆ椂...
绛旓細寰堝鏄,鍦˙1閲岄潰杈撳叆=A1+5,杩欐牱,浣燗1=100鏃,B1灏变細鑷姩鍙樻垚105,涓2000鏃,B1灏变細鍙樻垚2005
绛旓細鎸変綇Ctrl閿湪鐢ㄩ紶鏍囬変綘瑕侀夌殑鍦版柟
绛旓細1 閭ｄ釜鍥哄畾鏁版槸鍦涓涓鍗曞厓鏍硷紝姣斿璇村湪a1 锛岄偅浣犲湪閭ｄ竴鍒椾腑灏辨妸鍏紡鍚庡姞涓涓 -$a$1 锛岀劧鍚庝笅鎷夊氨鍙互浜 2 閭ｄ釜鏁颁笉鍦ㄦ煇涓涓崟鍏冩牸锛屾瘮濡備綘灏辨兂鍑20锛 閭ｄ綘灏卞湪涓涓┖鐧鐨鍗曞厓鏍煎啓20锛岀劧鍚庢嫹璐濆畠锛岄変腑浣犺鏀圭殑閭ｄ竴鍒楋紝鍙抽敭锛岄夋嫨鎬х矘璐 --- 鍕句笂鈥鏁板鈥濆拰鈥滃噺鈥 纭 3 ...
绛旓細1锛庢紨绀轰腑浣跨敤鐨勮蒋浠剁О涓篍xcel鐢靛瓙琛ㄦ牸锛岃蒋浠剁増鏈负Microsoftofficehome鍜宻tudentedition2016銆2锛庨鍏堬紝鎵撳紑涓涓狤xcel鐢靛瓙琛ㄦ牸骞跺垱寤轰竴涓柊鐨勭┖鐧借〃锛屼互婕旂ず濡備綍鏍规嵁鐗瑰畾鐨勬潯浠舵樉绀虹壒瀹鐨勫銆3锛庢牴鎹棶棰樻弿杩帮紝鎴戜滑鍦╝5cell涓緭鍏ュ鍥炬墍绀虹殑鍑芥暟锛屽畠浣跨敤宓屽鐨処F鍑芥暟鍜宖unction杩涜鍒ゆ柇锛屼粠鑰屽疄鐜板湪鐗瑰畾鏉′欢涓...
绛旓細randbetween(15,20)棣栧厛鏄庣‘randbetween鍑芥暟鐨勫惈涔夛紝randbetween鍑芥暟鏄殢鏈虹敓鎴愪綅浜庝竴涓尯闂鐨勬暟鍊肩殑涓涓嚱鏁般傚湪鏃ュ父鐨勫姙鍏腑鐢ㄧ殑鐩稿鐨勫箍娉涖俽andbetween鍑芥暟鏈変簩涓弬鏁帮紝绗竴鍙傛暟鍗充负鍖洪棿鐨勪笅闄愩傚嵆鏄负闅忔満鐢熸垚浣嶄簬涓涓尯闂寸殑涓嬮檺鐨勪竴涓暟鍊銆傜浜屽弬鏁颁负鍖洪棿鐨勪笂闄愩傚嵆鏄负闅忔満鐢熸垚浣嶄簬涓涓尯闂寸殑涓婇檺鐨勪竴...
绛旓細b1鐨勫叕寮忥細淇濇寔鍦0-19涔嬮棿 锛漨od(A1,20)
