1. 濡備綍鍦‥XCEL涓鑷鍔ㄧ粺璁″悇浜у搧鐨勬暟閲忓強鍗曚環銆
鍦‥xcel涓錛氳続1涓"鍝佸悕"錛岃綛1涓烘暟閲忥紝璁綜1涓哄崟浠鳳紝璁綝1涓洪噾棰濄
鍦˙2閲岃緭鍏ユ暟閲忊3鈥濓紝鍦–2閲岃緭鍏ュ崟浠"300"錛屽湪D2閲岃緭鍏ュ弻寮曞彿閲岄潰鐨勫叕寮忊=B2*C2鈥濓紝鐒跺悗鍥炶濺錛孌2閲岄潰灝卞緱鍑虹粨鏋滀簡鈥900鈥濄
浣犲傛灉鏈3縐嶅搧鍚嶏紝浣犵偣涓涓婦2錛屾妸榧犳爣鏀懼湪D2鐨勬嗕笂錛岃╅紶鏍囧嚭鐜伴粦鑹插皬+鍙鋒椂錛岀偣浣忛紶鏍囧乏閿錛屽悜涓嬫媺鍔ㄩ紶鏍囷紝鎷夊埌涓嬮潰3鏍兼澗寮榧犳爣錛岃繖鏍瘋繖3鏍煎氨閮借嚜鍔ㄦ嶅叆D2閲岄潰鐨勫叕寮忎簡錛屽湪鍓嶉潰鐨勬暟閲忓拰鍗曚環閲岄潰浠繪剰杈撳叆鏁板瓧錛孌鍒楅噷灝辮嚜鍔ㄥ緱鍑轟箻縐銆傚綋鐒朵綘涔熷彲浠ヤ竴琛屼竴琛岀殑杈撳叆鍏寮忋
浣犱竴瀹氭兂璁╁悇涓閲戦濊嚜鍔ㄧ浉鍔犲緱鍑哄悎璁￠噾棰濓紝浣犵偣浣廌2鍚戜笅鎷3鏍礆紝鏉懼紑榧犳爣錛岀劧鍚庨〉闈㈠彸杈歸《絝鎵懼埌 鈭鈥滆嚜鍔ㄦ眰鍜屸濓紝鐢ㄩ紶鏍囩偣涓涓嬶紝榪欐牱鎬婚噾棰濆氨鑷鍔ㄨ＄畻鍑烘潵浜嗐備篃鍙浠ュ湪D5閲岄潰杈撳叆鍙屽紩鍙烽噷闈㈢殑鍏寮忊=SUM(D2:D4)鈥濓紝鍥炶濺灝卞ソ浜嗐
