Ⅰ 濡備綍鎵撲貢excel琛ㄦ牸涓鏁版嵁鐨勯『搴忥紵
濡傛灉鎮ㄦ兂鎵撲貢 Excel 琛ㄦ牸涓鏁版嵁鐨勯『搴忥紝鍙浠ユ寜鐓т互涓嬫ラよ繘琛屾搷浣滐細
鍦 Excel 涓閫変腑鎮ㄨ佹墦涔辯殑鏁版嵁鎵鍦ㄧ殑琛屾垨鍒椼
鍦 Excel 鑿滃崟鏍忎腑鎵懼埌鈥滄暟鎹鈥濋夐」鍗★紝鐒跺悗鍦ㄤ笅鎷夎彍鍗曚腑閫夋嫨鈥滄帓搴忊濄
鍦ㄢ滄帓搴忊濆硅瘽妗嗕腑錛岄夋嫨鎮ㄦ兂瑕佹寜鐓у摢涓鍒楄繘琛屾帓搴忥紝鐒跺悗鍦ㄢ滄帓搴忔柟寮忊濋夐」涓閫夋嫨鈥滈殢鏈衡濄
鐐瑰嚮鈥滅『瀹氣濇寜閽錛孍xcel 灝變細灝嗘偍閫変腑鐨勬暟鎹闅忔満鎵撲貢銆
濡傛灉鎮ㄦ兂鍦ㄨ〃鏍間腑闅忔満鎵撲貢鏁翠釜琛屾垨鍒楋紝鍙浠ヤ嬌鐢 Excel 鍐呯疆鍑芥暟鈥淩AND()鈥濓紝鍏蜂綋鎿嶄綔濡備笅錛
鍦 Excel 琛ㄦ牸涓鎻掑叆涓涓鏂板垪鎴栨柊琛岋紝鐒跺悗鍦ㄧ涓涓鍗曞厓鏍艱緭鍏モ=RAND()鈥濄
鎸変綇鍗曞厓鏍煎彸涓嬭掔殑灝忛粦鐐癸紝灝嗗叕寮忓～鍏呭埌鎮ㄨ佹墦涔辯殑琛屾垨鍒椾腑鐨勬墍鏈夊崟鍏冩牸銆
灝嗚繖涓鍒楁垨琛屾寜鐓цュ垪鎴栬屼腑鐨勯殢鏈烘暟榪涜屾帓搴忓嵆鍙銆
榪欑嶆柟娉曞皢闅忔満鏁版彃鍏ュ埌鎮ㄧ殑琛ㄦ牸涓錛岀劧鍚庢牴鎹榪欎簺闅忔満鏁板規暟鎹榪涜屾帓搴忥紝浠庤屾墦涔辨暟鎹鐨勯『搴忋