① 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绛夌瓑