① excel濡備綍淇濈暀鏁板瓧鍚庡嚑浣嶆暟
excel鏄鎴戜滑甯哥敤鐨勬暟鎹澶勭悊宸ュ叿涔嬩竴錛屾湁鐨勬椂鍊欐垜浠浼氶渶瑕佹敞鎰忔暟鎹鐨勬牸寮忥紝鎺ヤ笅鏉ュ皬緙栧氨鏁欏ぇ瀹舵庢牱璁劇疆鏁版嵁鐨勪繚鐣欎綅鏁般
鍏蜂綋濡備笅錛1. 棣栧厛鎴戜滑鎵撳紑鐢佃剳榪涘叆鍒版岄潰錛屾壘鍒癳xcel鍥炬爣鐐瑰嚮鎵撳紑錛岃繘鍏ュ埌杞浠剁晫闈涔嬪悗錛屾垜浠鎵懼埌鎯寵佷繚鐣欎綅鏁扮殑鏁版嵁銆
2. 棣栧厛鎴戜滑閫変腑涓涓鏁版嵁瀛樻斁鐨勫崟鍏冩牸錛岀劧鍚庢垜浠鍦ㄤ笂鏂圭殑鍏寮忔爮涓杈撳叆鈥=left鈥濓紝鐒跺悗鍦ㄥ叕紺烘爮鐨勪笅鏂瑰氨浼氬脊鍑虹浉搴旂殑鍏寮忥紝鎴戜滑鏍規嵁鍏寮忚緭鍏ュ氨鍙浠ャ
3.鎺ヤ笅鏉ユ垜浠鍙闇瑕佹牴鎹鍏紺虹殑鏍煎紡杈撳叆鐩稿簲鐨勬暟鎹錛岄栧厛杈撳叆鎴戜滑閫夊彇鐨勫崟鍏冩牸鍦板潃銆
② 鍦╡xcel琛ㄦ牸涓濡備綍淇濈暀涓涓叉暟瀛楃殑鍚庝笁浣嶏紵濡87110錛87111錛87112錛岃繖鏍峰彧淇濈暀110 錛111 錛112榪欐牱鐨勶紝
濡傛灉鏁板瓧淇濆瓨鍦ˋ1, 閭ｅ氨鍦ㄤ換鎰忓崟鍏冩牸杈撳叆 =right(a1,3)
③ 濡備綍鎶奅XCEL涓鏁板瓧,鍏16浣,鍙鐣欏悗7浣,鍓╀笅鍓嶅嚑浣嶆庝箞鍒犻櫎
1銆丒XCEL琛ㄦ牸涓鏈変竴浜涙暟瀛楋紝鐜板湪鏄鎯充繚鐣欐暣鏁幫紝鑰屼笖鏄鍙屽嚮琛ㄦ牸鏃朵笉浼氬嚭鐜板皬鏁扮偣鍚庨潰鐨勬暟瀛椼
2銆佸彧鎯充繚鐣欐暣鏁幫紝閭ｄ箞錛屽彧瑕佸湪B鍒楄緭鍏ュ嚱鏁幫細=trunc(A1)銆
3銆佸仛瀹岀浜屾ュ悗錛屾寜涓涓鍥炶濺閿錛歟nter錛屽啀榪愮敤濉鍏呮焺涓嬫媺鍗沖彲寰楀埌鏁存暟浜嗭紝鏄涓嶆槸寰堢畝鍗曘
娉ㄦ剰錛氭埅灝懼彇鏁寸殑鍑芥暟鏈夊緢澶氥侷NT銆乀RUNC銆丷OUNDDOWN銆丷OUNDUP絳夌瓑