excel里请速给一个±5之间的随机函数? excel求函数,在正负0.5之间的随机数,不要0,
excel\u4e2d\u8ba9\u4e00\u4e2a\u6570\u5728+5\u548c-5\u4e4b\u95f4\u8df3\u52a8\u5728D8\u4e2d\u8f93\u5165\u6216\u590d\u5236\u7c98\u8d34\u4e0b\u5217\u516c\u5f0f\u4e4b\u4e00
=B8+0.001*RANDBETWEEN(-5,5)
=B8+RANDBETWEEN(-5,5)/1000
=B8+0.001*(RAND()*10-5)
=B8+(RAND()*10-5)/1000
\u4e0b\u62c9\u586b\u5145
\u53ef\u81ea\u5b9a\u4e49\u51fd\u6570\uff0calt+f11\uff0c\u63d2\u5165\u6a21\u5757\uff0c\u590d\u5236\u5982\u4e0b\u4ee3\u7801\u3002
\u5728\u672csheet\u4e2d\u4efb\u610f\u5355\u5143\u683c\u4e2d\u4f7f\u7528\u8be5\u51fd\u6570\u3002
Public Function Rand05()1: Rand05 = -0.5 + Rnd() * 1If Rand05 = 0 Then GoTo 1End Function
如果要包含5的话,用下面的公式:
=INT(RAND()*11-5)
如果是想得到+5到-5之间的数
要求整数吗?
INT(RAND()*10-5)
绛旓細鍙互浣跨敤RAND()鍑芥暟锛孯AND()*(b-a)+a鍙互寰楀埌a锛峛涔嬮棿鐨勯殢鏈烘暟锛岄偅涔圧AND()*10-5灏卞彲浠ュ緱鍒-5鍒5涔嬮棿鐨勯殢鏈烘暟銆
绛旓細5脳5涓笉閲嶅鐨1锛5鐨勬暟锛岃繖璇磋捣鏉ユ湁鐐逛笉鍙濊锛屽氨5涓暣鏁帮紝瑕佸畠鍙樻垚25涓笉閲嶅鐨勬暟鍙兘鍚楋紝鍙鏄浉鍚岀殑浣犻兘瑕佸鍔犱竴娆″惊鐜紝瀹冭兘涓嶈姳寰堥暱鏃堕棿鍚楋紝鍥犱负閲嶅鐨勬暟澶浜嗭紝浣犵敤5涓暟鍐欐垚25鏍硷紝浣犺兘鍐欏悧銆傛妸鈥淐ells(j, i) = Int(Rnd() * 5) + 1鈥濇敼鎴愨淐ells(j, i) = Rnd() * ...
绛旓細1.棣栧厛锛屾墦寮Excel锛屽湪瑕佹樉绀烘洿鏂版暟鎹殑鍗曞厓鏍煎鐐瑰嚮锛屽啀鐐瑰嚮鎻掑叆鍑芥暟鎸夐挳fx銆2.寮瑰嚭鎻掑叆鍑芥暟瀵硅瘽妗嗭紝鎺ヤ笅鏉ラ夋嫨绫诲埆涓哄叏閮紝鍦ㄤ笅鏂圭殑鍒楄〃妗嗕腑鎵惧埌Lookup鍑芥暟锛岀偣鍑荤‘瀹氥3.閫夋嫨绗簩绉嶆牸寮忥紝鐐瑰嚮纭畾锛屽脊鍑哄嚱鏁板弬鏁拌缃晫闈4.鍦ㄧ涓涓鍙傛暟妗嗕腑杈撳叆9E+307锛岃繖鏄竴涓瀛﹁鏁版硶锛屾剰鎬濇槸9*10^307銆備唬...
绛旓細1銆佸鍥句腑琛ㄦ牸鏁版嵁涓轰緥锛岄渶瑕佹妸姣忎釜鍗曞厓鏍肩殑涓涓叉暟瀛楁瘡闅3涓暟瀛楁坊鍔涓涓閫楀彿銆2銆佹妸琛ㄦ牸鍏ㄩ変腑銆傚啀濡傚浘鎵绀猴紝鐐瑰嚮杩欎釜灏忔寜閽3銆佸湪寮瑰嚭鐨勯潰鏉夸腑锛岀偣鍑绘暟瀛楅夐」锛屽啀鐐瑰嚮锛氳嚜瀹氫箟銆4銆佸湪绫诲瀷涓嬮潰鐨勭紪杈戞鍐咃紝杈撳叆锛000锛000锛5銆佸啀鐐瑰嚮纭畾鍗冲彲锛屾晥鏋滃鍥炬墍绀恒
绛旓細1銆佸湪妗岄潰鎵撳紑涓涓闇瑕佽繘琛屽彇鍊肩殑Excel琛ㄦ牸銆2銆侀変腑F2鍗曞厓鏍硷紝鈥滃叕寮忊--鈥滄彃鍏ュ嚱鏁扳--鈥淟EFT鈥濆嚱鏁般3銆佸湪寮瑰嚭鐨勫嚱鏁板弬鏁板璇濇涓紝鎸夌収涓嬪浘璁剧疆鍙傛暟銆4銆佸崟鍑荤‘瀹氬悗鐨勬晥鏋滃涓嬪浘锛岀劧鍚庡埄鐢ㄥ~鍏呭姛鑳藉皢鍏紡濉厖鍒癋3锛欶12鍗曞厓鏍笺5銆佸湪鈥滄暟鎹濋夐」锛屽湪鈥滄暟鎹伐鍏封濋夐」缁勪腑锛屽崟鍑烩滃垎鍒椻濋夐」銆6銆...
绛旓細鍦ˋ1杈撳叆=RAND()濡傞渶瑕140涓暟灏变笅鎷夊埌A140.锛堥渶瑕佸灏戜釜鍙笅鎷夊灏戜釜锛夊湪B1杈撳叆=RANK锛圓1锛$A$!:$A:$A$140锛+410锛堟澶勭殑$140浠鍒椾笅鎷夋牸鏁颁负鍑嗭紱鍔犲彿鍚庨潰鐨勬暟瀛椾互浣犻渶瑕佸紑澶寸殑鏁板瓧涓哄噯锛屽闇0-XX鐨勶紝鍙渷鐣ュ姞鍙峰強鍚庨潰鐨勬暟瀛椼傦級B1杈撳叆鍚庡洖杞︼紝涓嬫媺鍒伴渶瑕佺殑鏁伴噺锛屾鏁伴噺鍐呯殑鏁板瓧鍧囦负鏁存暟...
绛旓細鐢ㄦ潯浠舵牸寮忥紝閫変腑闇瑕佹敼鍙橀鑹茬殑鍗曞厓鏍硷紝濡侫2涓哄師璁″垝閲戦锛孊2涓哄疄闄呭畬鎴愮殑閲戦锛岄変腑B2鏍煎紡->鏉′欢鏍煎紡->閫夋嫨鍗曞厓鏍兼暟鍊->閫夋嫨澶т簬鎴栫瓑浜->杈撳叆浣犵殑鍘熻鍒掗噾棰->閫夋嫨浣犻渶瑕佺殑涓牸->澧炲姞涓涓鏉′欢->閫夋嫨鍗曞厓鏍兼暟鍊->閫夋嫨灏忎簬->杈撳叆浣犵殑鍘熻鍒掗噾棰->閫夋嫨浣犻渶瑕佺殑涓牸->纭銆
绛旓細鍦╯heet3涓殑D5鍗曞厓鏍艰緭鍏ワ紙鎴栧鍒讹級浠ヤ笅鍏紡锛=IF(ISERROR(VLOOKUP(A5,Sheet2!A:D,4,0)),"",VLOOKUP(A5,Sheet2!A:D,4,0))鍗冲彲