excel请高手指导一下啊,谢谢 如图:请Excel高手帮忙解答一下,谢谢!
\u9ad8\u624b\u6307\u5bfc\u4e00\u4e0b\u8c22\u8c22\uff1f\u5206\u6790:\u9634\u5f71\u90e8\u5206\u662f\u6b63\u65b9\u5f62\u51854\u4e2a\u76f8\u540c\u534a\u5f84\u4e3a5\u5706\u7684\u91cd\u53e0\u90e8\u5206\u3002\u6240\u4ee5
S\u9634=4S\u534a\u5706-S\u6b63\u65b9\u5f62
=2\u03c05²-10\u00d710
=50\u03c0-100
=157-100
=57cm²
\u5728D2\u5355\u5143\u683c\u8f93\u5165\u4ee5\u4e0b\u516c\u5f0f\uff0c\u7136\u540e\u5411\u4e0b\u586b\u5145\u516c\u5f0f
=SUM(C$2:C2)-C2
\u5728E2\u5355\u5143\u683c\u8f93\u5165\u4ee5\u4e0b\u516c\u5f0f\uff0c\u7136\u540e\u5411\u4e0b\u586b\u5145\u516c\u5f0f
=IF(ROW()-2>=SUM(C:C),"",LOOKUP(ROW()-2,D$2:D$4,A$2:A$4))
\u8be6\u89c1\u9644\u56fe\u4e3e\u4f8b
绛旓細Excel楂樻墜璇疯繘:濡備綍鍦ㄧ數瀛愯〃鏍间腑鍥哄畾鏌愪竴琛屾垨鏌愪竴鍒 ,灏辨槸璇村湪褰曞叆鏁版嵁鏃,鍙互婊氬姩鍏跺畠鐨勮鍒,浣嗚〃鏍煎緢鑳藉澶,鎴戦渶瑕佸浐瀹氬瓧娈佃,涓嶈瀛楁琛屾粴鍔,璋㈣阿鍙槸,鎴戝彧鎯冲喕缁撴煇涓琛,鍙槸,鎴戣缃簡涔嬪悗鍐荤粨浜嗗ソ澶氳,杩欐槸鎬庝箞鍥炰簨鍛?... ,灏辨槸璇村湪褰曞叆鏁版嵁鏃,鍙互婊氬姩鍏跺畠鐨勮鍒,浣嗚〃鏍煎緢鑳藉澶,鎴戦渶瑕佸浐瀹氬瓧娈佃,...
绛旓細鎵撳紑 鎴戠殑鐢佃剳锛嶏紞宸ュ叿锛嶏紞鏂囦欢澶归夐」锛嶏紞鏂囦欢绫诲瀷锛嶏紞锛嶅凡娉ㄥ唽鐨勬枃浠剁被鍨 鎵惧埌 xls锛嶏紞鏇存敼锛嶏紞 microsoft office excel 鎴栨祻瑙堟壘鍒 excel绋嬪簭 锛堜竴鑸湪C锛歕program files\锛
绛旓細鐢EXCEL鐨勬湅鍙嬩細鍙戠幇锛氬湪excel琛ㄦ牸涓紝杈撳叆瀹屾暟鎹悗锛屽湪鍗曞厓鏍肩殑宸︿笂瑙掑嚭鐜颁簡涓涓豢鑹茬殑涓夎锛屾湁浜嗚繖涓豢鑹茬殑灏忎笁瑙掕灏辨棤娉曡嚜鍔ㄦ眰鍜岋紝涔熷父甯稿洜涓哄叾涓湁涓涓垨鍑犱釜琛ㄦ牸鏈変簡杩欎釜缁胯壊灏忎笁瑙掑舰鑰屽鑷磋嚜鍔ㄦ眰鍜屾暟鎹敊璇紝鎬庢牱鍘婚櫎excel琛ㄦ牸涓乏涓婅鐨勭豢鑹插皬涓夎鍛紵鍒板簳璧风潃鎬庢牱鐨勪綔鐢ㄥ憿锛熼鍏堜负浠涔堜細鏈夎繖涓...
绛旓細4銆佽緭鍏ュ叕寮=VLOOKUP($F4&G$3,IF({1,0},$A:$A&$C:$C,$B:$B),2,FALSE) 锛堚滆寰楋紝鍏紡瑕佷笁閿粨鏉燂紝杩欐槸閲嶇偣 ctrl+shift+enter 鈥濓級鐒跺悗鍙虫媺銆佷笅鎷夈傚叕寮忎腑鐨勫崟鍏冩牸寮曠敤鏄牴鎹釜浜虹殑鏁版嵁琛ㄦ湁涓嶅悓锛屼綘绋嶅井鏀涓涓銆備笅杈圭粰浣犱釜鍥撅紝涓嶇煡閬撳浘鍟ユ椂鍊欒兘瀹℃牳閫氳繃锛屼綘鍏堣繖涔堢湅锛岀湅鐪嬭兘鐪嬫噦涓嶃
绛旓細淇敼涓涓銆傛渶鍚庣洿鎺ュ鍑轰负EXCEL銆3銆佸洜杞崲鐨凟XCEL鏁版嵁涓彲鑳芥湁寰堝绌烘牸锛屾鍙疯礋鍙烽櫎鍙风瓑绗﹀彿涓嶄竴瀹氭槸鍗婅锛屾墍浠ヤ篃闇鍒嗗埆鐢ㄦ煡鎵惧姛鑳芥浛鎹竴涓嬨4銆佲滃悎璁♀濈瓑浣跨敤鍏紡鐨勫崟鍏冩牸閲嶆柊杈撳叆鍏紡銆5銆佹湁蹇呰鐨勮瘽锛岃皟鏁磋〃鏍兼牸寮忋侽K 浠ヤ笂鏂规硶缁濆鍙锛屽鏋滀綘娌℃湁鎼炴垚鍔燂紝鑲畾鏄湁鍦版柟鎿嶄綔涓嶅綋锛岃浠旂粏妫鏌ャ
绛旓細杈撳叆鍏紡鏈夐棶棰橈紝濡備笅鍥撅紝鍦–2杈撳叆鍏紡锛岀洿鎺ョ偣A1鍜孊2鍗曞厓鏍煎氨鍙互銆
绛旓細鐪嬩笉娓呬綘鍐欑殑鍟ワ紝杩欑鑼冨洿鐨勫垽鏂紝寰堝鏄撶姱鐨勯敊璇槸鍐欐垚绫讳技浜巌f(90>x>=80杩欑涓滆タ锛孍XCEL閲屾槸娌℃湁杩欑鍐欐硶鐨勶紝濡傛灉鏄琛ㄨ揪绫讳技鐨勫惈涔夛紝搴旇鏄痠f(and(90>x,90<=x)锛屽彟澶栵紝瀵逛簬鍖洪棿鐨勫垽鏂竴鑸缓璁敤lookup锛屽畠姣攊f瑕佺畝鍗曪紙鑰屼笖if鐨勫祵濂椾篃涓嶈兘瓒呰繃7灞傦級锛屾瘮濡傛垚缁╁湪d1锛閭e叕寮忓氨鍙互鏄 =LOOKUP...
绛旓細鍥犱负閭d簺鏁版嵁鏄枃鏈牸寮忕殑锛岄渶瑕佽浆鎹负鏁板笺傞変腑鏁版嵁鍒楋紝鏁版嵁锛嶅垎鍒楋紞瀹屾垚銆傚鏋滆繖鏍蜂笉琛岋紝鍒欐暟鎹紞鍒嗗垪锛嶄笅涓姝ワ紞涓嬩竴姝ワ紞甯歌锛嶅畬鎴愩傚鏋滆繖鏍疯繕涓嶈锛岄偅涔堟槸鏁版嵁閲屾湁绌烘牸鎴栦笉鍙瀛楃锛岃灏嗚繖浜涚┖鏍煎垹闄ゆ墠琛屻
绛旓細鍋囧鏁版嵁鍦ˋ鍒 B1杈撳叆鍏紡=REPLACE(A1,FIND("=",A1),1,"=鎵归噺娣诲姞鐨勫瓧姣")鍏紡涓嬫媺澶嶅埗
绛旓細绌哄崟鍏冩牸涓嶆槸鐪熺┖锛屽彲鑳藉寘鍚┖鏍煎瓧绗︼紝灏嗙┖鐧藉崟鍏冩牸閫変腑锛屾寜Delete鍒犻櫎灏辫浜嗐備篃鍙互灏嗗叕寮忔敼涓猴細=SUM(B3:D3)锛堜絾瑕佹敞鎰忔暟瀛楀繀椤讳负鏁板兼牸寮忋傦級